The mysql_affected_rows() function will tell you how many rows were affected by the DELETE query you just fired. You can also test for TRUE or FALSE on the mysql_query() function if you just want to know if the query was successful or not. Rich -----Original Message----- From: ron.php [mailto:ron.php@xxxxxxxxxxxxxxxxxx] Sent: Friday, October 05, 2007 9:52 AM To: php-db@xxxxxxxxxxxxx Subject: Query executing How would I know if this mySQL query: DELETE FROM `table` WHERE `date_to_be_deleted` LIKE '$todays_date' actually deleted any rows from the table? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php