PHP 4.0 Bug #9734: Error
| From: | ahmed at nmt dot edu | Date: | Tue, 13 Mar 2001 20:42:07 +0000 |
| Subject: | PHP 4.0 Bug #9734: Error | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-48834@lists.php.net to get a copy of this message | ||
From: ahmed@nmt.edu
Operating system: Unix
PHP version: 4.0.4pl1
PHP Bug Type: MySQL related
Bug description: Error
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 ());
}
--
Edit Bug report at: http://bugs.php.net/?id=9734&edit=1