ID: 9734
Updated by: cynic
Old-Status: Open
Status: Bogus
Bug Type: MySQL related
PHP Version: 4.0.4pl1
Assigned To: 

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)


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);
$result = mysql_query($Query, $db);
$rows = mysql_num_rows($result);
if ($rows>0) {
           $Query="DELETE FROM  MY_DATA WHERE$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

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to