Print the SQL statement $query just before you call mssql_query() - make sure the SQL going in is what you think it is. Also, check mssql_affected_rows() after the call to make sure something was modified.
Stuart -----Original Message----- From: Joshua E Minnie [mailto:[EMAIL PROTECTED]] Sent: 29 April 2002 20:21 To: [EMAIL PROTECTED] Subject: Re: [PHP] Deleting from a SQL db "Stuart Dallas" <[EMAIL PROTECTED]> wrote: > Replace the die("...") with die(mysql_error()) and the message should tell > you what's wrong. It never gets to the die("...") statement. The script is returning a positive integer from the mssql_query() function. I am not seeing it ever throw an error. It just doesn't delete. Here is the URL of the running script: http://www.acsurf.net/php_db/sql_test.php. I am trying to delete the username josh. -- Joshua E Minnie/CIO [EMAIL PROTECTED] 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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
