Posted by "Shaun" on 10/18/05 20:10

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/

[Back to original message]