RE: [PHP-DB] Query executing
| From: | Hutchins, Richard | Date: | Fri, 05 Oct 2007 13:57:33 +0000 |
| Subject: | RE: [PHP-DB] Query executing | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44162@lists.php.net to get a copy of this message | ||
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@actsministries.org]
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