[SOLVED] finding out a null value

[marklarah]

mysql_query("INSERT INTO topics (ID, Name, CBy, Last_post, Board) VALUES(NULL,  '$mtit', '$usernamem', NOW(), '$boardA') ") or die(mysql_error());  

mysql_query("INSERT INTO messages (messageid, topic, username, time, message, board) VALUES(NULL,  'its here i need to find out that null value entered', '$usernamem', NOW(), '$mcont', '$boardA') ") or die(mysql_error());  

 

So how do i find out that NULL value inserted in the first query to inert into the second one? Its auto_increment the ID field.

 

thanks.

[marklarah]

is there some super-secret special NULL variable only known to everyone but me?

[wildteen88]

if you are listing your fields in your query, then you can remove the fields which will receive a null value.

mysql_query("INSERT INTO topics (Name, CBy, Last_post, Board) VALUES('$mtit', '$usernamem', NOW(), '$boardA') ") or die(mysql_error());  

mysql_query("INSERT INTO messages (topic, username, time, message, board) VALUES('its here i need to find out that null value entered', '$usernamem', NOW(), '$mcont', '$boardA') ") or die(mysql_error()); 

[papaface]

http://uk3.php.net/manual/en/function.mysql-insert-id.php is what you want.