Hi Ben, Thanks for your reply, woudn't that insert a string with a value of'NULL';? ""Ben Litton"" <ben.litton@xxxxxxxxx> wrote in message news:op.syun6jsq1nzadm@xxxxxxxxxxxxxxxxxxxxxxx > Either cast your empty ints (which should make it zero) or do an if > (!isset($variable)) { $variable = 'NULL'; } > > Ben > > On Tue, 18 Oct 2005 12:15:41 -0400, "Shaun" <shaunthornburgh@xxxxxxxxxxx> > wrote: > >> 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 > > > > -- > Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
