Hello,

I'm trying to update a mysql database with a variable $to. Depending on the value of $to, NULL or $to has to be entered.
Is there a way of updating the database with $to=NULL?

update(table set column = $to where...) with $to NULL or another value.

Hope you understand the question,

Thx for you advice!

jango

Yes but you need to do:

mysql_query("update table table_name set column='.$to.' where ....");

if variable $to comes from post or get request then you need this before insert statement:

if(!$to || $to=="" || $to===NULL){
$to = "NULL"; //string
}

mysql_query.......