try the WHERE clause. SELECT name, address, phone, date FROM usertable WHERE date = '0000-00-00' And please, look at the mysql documentation, or at least the tutorial. -- Marcjon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
