DaniWeb Forum Index > Web Development > PHP

query executes and return correct value but cudnt save one value into db

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2008

Posts: 6

Reputation: mm2409 is an unknown quantity at this point

Solved Threads: 0

mm2409

Offline

Newbie Poster

query executes and return correct value but cudnt save one value into db

Dec 12th, 2008

lines of code is:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$que_id = uniqid();
$que['Yes'] = No;
$que['No'] = No;
$que[$_POST['r1']] = Yes;
 
$que_words1= $_POST['q1'];
$sql = "INSERT INTO `tbl_CT_Questions` (`Question_ID`,`Questionnaire_ID`,`Question_Words`,`Answer_Type`) 
VALUES (0,'".$que_id."','".$que_words1."','".$que[$_POST['r1']]."')";
 
$result = mysql_query($sql) or die(mysql_error()) ;
echo mysql_error();
echo $sql;
echo "<br>";
$que_id = uniqid();
$que['Yes'] = No;
$que['No'] = No;
$que[$_POST['r1']] = Yes;

$que_words1= $_POST['q1'];
$sql = "INSERT INTO `tbl_CT_Questions` (`Question_ID`,`Questionnaire_ID`,`Question_Words`,`Answer_Type`) 
VALUES (0,'".$que_id."','".$que_words1."','".$que[$_POST['r1']]."')";

$result = mysql_query($sql) or die(mysql_error()) ;
echo mysql_error();
echo $sql;
echo "<br>";

whr query returns :

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
INSERT INTO `tbl_CT_Questions` (`Question_ID`,`Questionnaire_ID`,`Question_Words`,`Answer_Type`) VALUES (0,'494220e779547','Conflicts Questionnaire','Yes')
INSERT INTO `tbl_CT_Questions` (`Question_ID`,`Questionnaire_ID`,`Question_Words`,`Answer_Type`) VALUES (0,'494220e779547','Conflicts Questionnaire','Yes')

as u see 'Answer_Type' in query returns value 'Yes' but i cudnt see it into table...whr into databse 'Answer_Type' has datatype 'enum'

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