------=OPENWEBMAIL_ATT_0.949825041500059
Content-Type: text/plain;
charset=iso-8859-1
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
------=OPENWEBMAIL_ATT_0.949825041500059--
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
> 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?
www.php.net/mysql_affected_rows
Greetings,
Thomas Tschernich
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php