Re: Inserting NULL Integer Values
| From: | Richard Lynch | Date: | Tue, 18 Oct 2005 18:41:37 +0000 |
| Subject: | Re: Inserting NULL Integer Values | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-224292@lists.php.net to get a copy of this message | ||
$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