anything compared to NULL is always false
Actually it's null. mysql> select false = null; +--------------+ | false = null | +--------------+ | NULL | +--------------+ 1 row in set (0.01 sec) mysql> select 1 = null; +----------+ | 1 = null | +----------+ | NULL | +----------+ 1 row in set (0.00 sec) mysql> select 2 = null; +----------+ | 2 = null | +----------+ | NULL | +----------+ 1 row in set (0.00 sec) unknown compared to anything is unknown. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php