Deleting from a SQL db
| From: | Joshua E Minnie | Date: | Mon, 29 Apr 2002 19:11:06 +0000 |
| Subject: | Deleting from a SQL db | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-95224@lists.php.net to get a copy of this message | ||
Can anyone help me understand why this code is not deleting the row from the
MS SQL db like it should.
<?
...
$query = "DELETE FROM users WHERE user = '$user'";
$result = @ mssql_query($query) or die("Unable to delete user");
if($result >= 0) echo "User successfully deleted.<br>\n";
...
?>
I am running PHP 4.1.2 binary on Windows NT 4.0 with MS SQL Server 2000
running on Windows 2000.
--
Joshua E Minnie/CIO
josh@acsurf.net
Phone: 616.276.9690
Fax: 616.342.8750
Nextel: 616.862.2847
"Don't work for recognition, but always do work worthy of recognition."