[PHP] Re: Inserting NULL Integer Values

[Ben Litton]

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" <[EMAIL PROTECTED]>  
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