How to set a MySQL field to NULL Using PHP3

[Anon]

using PHP3 I would like to set a MySQL database field to the NULL value. Simply using:

$result = MYSQL_QUERY(UPDATE $user_table SET xxx=\"NULL\");

enters the acutal letters NULL into the record when I want the value of NULL.

any ideas?

Thank you in advance
Ron
Northern Vermont USA

[Anon]

if your field in mySQL is set to lets says

number integer(3) NOT NULL DEFAULT '000'

then using php, you can do:
$result = MYSQL_QUERY(UPDATE $user_table SET number="");

that will always create an entry with the DEFAULT value.

hope this is what you are looking for.

[Anon]

yes, that is exactly what I was looking for. Thank you very much.