Posted by "Richard Lynch" on 10/18/05 21:41

$value2 = strlen($value2) ? $value2 : 'NULL';

On Tue, October 18, 2005 11:15 am, Shaun 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
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


--
Like Music?
http://l-i-e.com/artists.htm

• Next in forum: Recommended Reading?
• Prev in forum: Re: [PHP] Re: Inserting NULL Integer Values
• Thread view: Re: [PHP] Inserting NULL Integer Values

[Reply to this message]