Ok, as best I can tell, the following code should insert the variables into the table, which it does do, and it should set the date in a timestamp feild, which it dosen't. Bugger. The timestamp feild would be the last of the 5 INSERT intos btw. I hope that makes sense
if (mysql_num_rows($result) == 0) {
echo 'Sorry, your question is not in our database<P>';
echo '<a href="search.php">Perform another search</a>';
$no = No;
$notasked=mysql_query("INSERT INTO ansr_info VALUES ('','$search','','$no','')");
}
Always the way. You finally give in and accept you can't do it and post on the forums, and seconds later you get the answer. Just FYI, it worked with the following code...
if (mysql_num_rows($result) == 0) {
echo 'Sorry, your question is not in our database<P>';
echo '<a href="search.php">Perform another search</a>';
$no = No;
$notasked=mysql_query("INSERT INTO ansr_info (question, answer, answered) VALUES ('$search','','$no')");
}