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

generating random id and save it into db

Dec 3rd, 2008

dear frnds,

i hace wrote this code to generate unique id for questionnaire and a query to save it into database with two more value (response id and date)

individually i have checked and unique id function is working.
even insert query is also executing correctly.

but when i put it whole into my php file it doesnt save values into DB.

please help to sort it out. i m in hurry.

code is here:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$que_id = uniqid(que);
echo $que_id;
echo "<br>";
 
$db->query("INSERT INTO tbl_CT_Responses (Response_ID,Questionnaire_ID,Response_Date) 
VALUES (".GetSQLValueString("",`int`).","
.GetSQLValueString($que_id,`int`).","
.GetSQLValueString(date('Y-m-d'),`date`)
.")");
 
echo "The questionnaire ID is inserted successfully";
?>
$que_id = uniqid(que);
echo $que_id;
echo "<br>";

$db->query("INSERT INTO tbl_CT_Responses (Response_ID,Questionnaire_ID,Response_Date) 
VALUES (".GetSQLValueString("",`int`).","
.GetSQLValueString($que_id,`int`).","
.GetSQLValueString(date('Y-m-d'),`date`)
.")");

echo "The questionnaire ID is inserted successfully";
?>

Last edited by peter_budo; Dec 3rd, 2008 at 6:53 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.