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:
$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"; ?>