Re: Inserting NULL Integer Values

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/