RE: [PHP] Deleting from a SQL db

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:josh@acsurf.net] Sent: 29 April 2002 20:21 To: php-general@lists.php.net Subject: Re: [PHP] Deleting from a SQL db "Stuart Dallas" <stuart@sharedserver.net> 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 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." -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php