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

Expand Post »

lines of code is:

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 :

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.

mm2409

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Dec 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: download, install & redirect

Next Thread in PHP Forum Timeline: Some1 who know how can I put PTC site info into a banner???

DaniWeb Message

Cancel Changes

User Name
Password