Replace the die("...") with die(mysql_error()) and the message should tell
you what's wrong.


-----Original Message-----
From: Joshua E Minnie [mailto:[EMAIL PROTECTED]]
Sent: 29 April 2002 20:11
Subject: [PHP] Deleting from a SQL db

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
Phone: 616.276.9690
Fax: 616.342.8750
Nextel: 616.862.2847

"Don't work for recognition, but always do work worthy of recognition."

PHP General Mailing List (
To unsubscribe, visit:

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to