Inserting NULL Integer Values

["Shaun" <shaunthornburgh@xxxxxxxxxxx>]

Hi,

Up to this point in time I used to construct my insert statements like this

$qid = mysql_query('INSERT INTO MYTABLE (
                                column1,
                                column2,
                               ) VALUES (
                                "'.$value1.'",
                                "'.$value2.'"
                               )');

However I understand it is better to remove the quote marks around an insert 
if the column type is an integer. This is easy to do, however if the $value 
is empty it causes a mysql error. Has anyone encountered this and found a 
solution?

Thanks for your advice 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php