PHP/Mysql not inserting null values!

[slate]

In this piece of a line of code:

 

$result = sql_query(\"INSERT INTO map_points VALUES (\'$point_id\', \'$point_title\', \'$point_desc\', etc...

 

 

it $point_title is empty (null) in the form, and the default value is NULL, why is it being inserted as 0 into the database?

[slate]

Figured it out myself...

There\'s a bug in mysql (according to mysql.com) so I have to do this:

 

$valsToInsert = \"\";

 

if ($point_id != \"\")

{

$valsToInsert = $valsToInsert . \"\'$point_id\'\";

}

else

{

$valsToInsert = $valsToInsert . \"NULL\";

}

 

for each $string i need to check it.