|
Posted by "Ben Litton" on 10/18/05 21:29
Yes, but NULL is a special thing to MySQL. If you don't quote 'NULL' it
just means 'empty' to mySQL. If your database schema allows NULLS (it's
optional), your insert will go through.
On Tue, 18 Oct 2005 13:10:32 -0400, "Shaun" <shaunthornburgh@hotmail.com>
wrote:
> 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/
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
[Back to original message]
|