Hi I have a table with one row and twelve fields all named 1 to 12.
I am trying to update one field to NULL. I can do this when not using any variables for the table name, field name etc but once I use variables I cant get it to work. My table is set up to accept null values.
I have tried an endless number of variations and scoured the internet but nothing seems to work.
This was my latest attempt at 1am but still get error messages.
[php]$sql2 = “UPDATE ‘$table’ SET ‘$field’ = NULL WHERE ID= 1”;[/php]
Thanks in advance
Chipie