set value to NULL in mysql

[Bastien]

how do i set a value to null

currently using

$sql_hold="update booth_status set booth_status = 0, company='' where booth_id = $id";

but thnik null is a better option


$sql_hold="update booth_status set booth_status = 0, company=NULL where booth_id = $id";

doesn't seem to work

help please



Bastien

cat, the other other white meat

 

[sleipnir214]

Your use of NULL here is correct.

How are you testing that it is set to NULL? There is a difference between a NULL value and an empty value.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!