Re: Deleting from a SQL db

"Stuart Dallas" <stuart@sharedserver.net> wrote: > 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. It is writing the proper $query. The reason for the error is missing "[]" around the table and field names. I don't know why this didn't throw an error in other parts of the script but it works fine now that I added them. > > 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."