simple error

[Toy]

$result = mysql_query("SELECT * FROM table ORDER BY RAND() LIMIT 1");
while($display = mysql_fetch_array($result))
if ($display['type'] == "yes")
{
$result2 = mysql_query("SELECT * FROM table2 ORDER BY RAND() LIMIT 1");
while($display2 = mysql_fetch_array($result2))
echo ''. $display2['good'] .' <h1>'. $display['type'] .'</h1><img src="'. $display['answer'] .'">';
mysql_query("INSERT INTO ga (question, answer, image, comment) VALUES ('$_POST[text]','$display[type]','$display[answer]','$display2[good]')");
}
else
{
$result3 = mysql_query("SELECT * FROM table3 ORDER BY RAND() LIMIT 1");
while($display3 = mysql_fetch_array($result3))
echo ''. $display3['bad'] .' <h1>'. $display['type'] .'</h1><img src="'. $display['answer'] .'">';
mysql_query("INSERT INTO ga (question, answer, image, comment) VALUES ('$_POST[text]','$display[type]','$display[answer]','$display3[bad]')");
}

 

it should insert four fields to db, question, answer, image, comment however it doesn't insert comment, i have no idea why.

[jcbones]

Neither do we.  As we don't have your database tables, or any other information that could possibly point us to what is in $display['bad'].

[Toy]

in  $display bad is just a word , the same for display good