ID: 9734
Updated by: cynic
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Bogus
Bug Type: MySQL related
PHP Version: 4.0.4pl1
Assigned To:
Comments:
watch this:
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| foo |
+----------------+
1 row in set (0.00 sec)
mysql> select * from foo;
+--------------+
| bar |
+--------------+
| 999999999.99 |
+--------------+
1 row in set (0.00 sec)
mysql> delete from foo where bar = 'hello';
Query OK, 0 rows affected (0.00 sec)
mysql>
the truth is that delete of 0 rows is NOT an error.
Previous Comments:
---------------------------------------------------------------------------
[2001-03-13 21:42:07] [EMAIL PROTECTED]
It seems like the DELETE query don't return any error so I have to test first for the
existing of the element than if exist I'll delete it.
$db = mysql_connect("localhost", "root");
mysql_select_db("MY_DBASE", $db);
$Query="SELECT * FROM MY_DATA WHERE MY_DATA.id=$id";
$result = mysql_query($Query, $db);
$rows = mysql_num_rows($result);
if ($rows>0) {
$Query="DELETE FROM MY_DATA WHERE MY_DATA.id=$id";
mysql_query($Query, $db);
print("<P align=center><font size=6 face=italic><strong>Recored
$id deleted</strong></font>n");
}
else {
printf ("<P align=center><font size=6 face=italic><strong>
Error deleting record!:</strong> %s</font>n",
mysql_error ());
}
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=9734&edit=2
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
