On 8/8/07, Brent Baisley <[EMAIL PROTECTED]> wrote: > One thing to check is to make sure you are not quoting your NULL > value for your insert statement. MySQL will try to convert that to a > numeric value, which may end up as 0. > > On Aug 8, 2007, at 12:55 PM, Mahmoud Badreddine wrote: > > > Hello > > I have a table which contain a few numerical values. > > I set the default values to be NULL. > > When I insert values using phpMyAdmin, it sets the values to NULL > > correctly. > > But when I insert using a PHP script that I wrote it sets the values > > to 0.00or 0. > > In my script I do test if the values are empty and in case they are > > I set > > the variable to NULL. But that still doesn't help. > > Is that a mysql problem ? > > Thank you. > > > > -- > > -Mahmoud Badreddine > > > > http://www.spreadfirefox.com/ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > As long as you are testing to see if they should be null, and the default is set to null, you could exclude the column all together from the insert statement and you should see they are then recorded in the table as null.
cj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
