mm2409 0 Newbie Poster

lines of code is:

$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 :

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'

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.