Hi I added the following statement at the end of the my.cnf file: sql-mode="STRICT_ALL_TABLES,ALLOW_INVALID_DATES"
but I still got the values 0 and 0.00 where no values were entered. I did restart the the mysql daemon of course. What am I still doing wrong? Thanks. On 8/8/07, Christian High <[EMAIL PROTECTED]> wrote: > > 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 > -- -Mahmoud Badreddine http://www.spreadfirefox.com/