"Stuart Dallas" <[EMAIL PROTECTED]> 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
[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
