Entry

How do I insert a null into mysql using a php var? i.e. '$x' where $x could be null or have a value

May 21st, 2001 17:14
Onno Benschop, Brad Ford, Ben Udall,

Use this construct:
($x?'NULL':$x)
If $x is empty then the text substituted will be NULL, otherwise $x.
Sample:
$x = ($x?'NULL':$x) ;
$select = "INSERT INTO table (myField) VALUES ($x)" ;