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@xxxxxxxxxxx>
wrote:
Hi Ben,
Thanks for your reply, woudn't that insert a string with a value
of'NULL';?
""Ben Litton"" <ben.litton@xxxxxxxxx> wrote in message
news:op.syun6jsq1nzadm@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxx>
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/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
