RE: [PHP] testing a query for success--code doesnt work
| From: | (Edward Peloke) | Date: | Tue, 04 Feb 2003 20:50:50 +0000 |
| Subject: | RE: [PHP] testing a query for success--code doesnt work | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-134328@lists.php.net to get a copy of this message | ||
I think you want to use mysql_affected_rows
-----Original Message-----
From: Sunfire [mailto:rusty_81@msn.com]
Sent: Tuesday, February 04, 2003 3:51 PM
To: php-general@lists.php.net
Subject: [PHP] testing a query for success--code doesnt work
hi..
posted a message about what the code was to test an update query to see if
it was successfull using mysql and i tested my code and for some reason even
if none of the fields were updated it still reports the success message...
heres the code i have:
$query=mysql_query("update members set company="\$company\", ........);
if($query){
message if successfull...
}
else{
message if not or if failed..//never gets used
}
anybody know why this doesnt work if 0 records were changed?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php