Re: Inserting NULL Integer Values

Hi Ben, Thanks for your reply, woudn't that insert a string with a value of'NULL';? ""Ben Litton"" <ben.litton@gmail.com> wrote in message news:op.syun6jsq1nzadm@ben.scienceboard.org... > 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@hotmail.com> > 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/