Delete and set for NULL

[dannybrazil]

Hello
after deleting an entry i want to change the field in to NULL(not the string)

i did this :

mysql_query("UPDATE _Form_Nr_2 SET $photo_number='NULL' WHERE id=$id ");

but it seems NOT to work

any help ?

[NogDog]

No quotes around NULL (it's a keyword, not a string literal). On a side note, do you really want to use the variable $photo_number for the column name, or should it just be photo_number (no "$") as the actual column name?

[dannybrazil]

the $photo_number is a variable that will change every time the user will delete a specific page so every photo sits in a different column

i'll try and will write back

thanks

[dannybrazil]

working !

thanks