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:[EMAIL PROTECTED] Sent: Friday, October 05, 2007 9:52 AM To: php-db@lists.php.net Subject: [PHP-DB] 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
