DaniWeb IT Discussion Community - View Single Post - generating random id and save it into db

Re: generating random id and save it into db

Dec 4th, 2008

have you to tried to check the mysql errors?

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
echo mysql_error();
echo mysql_error();

or an alternative to the insert statement

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$db->query("INSERT INTO tbl_CT_Responses 
SET 
Response_ID=".GetSQLValueString("",`int`).",
Questionnaire_ID=".GetSQLValueString($que_id,`int`).",
Response_Date=".GetSQLValueString(date('Y-m-d'),`date`)."
");
$db->query("INSERT INTO tbl_CT_Responses 
SET 
Response_ID=".GetSQLValueString("",`int`).",
Questionnaire_ID=".GetSQLValueString($que_id,`int`).",
Response_Date=".GetSQLValueString(date('Y-m-d'),`date`)."
");

hope it will work out for you.

:: xarz ::