Reply to Re: Inserting NULL Integer Values

Your name:

Reply:


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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация