Windows 2000, php 4.04, IIS, MS SQL db

[Anon]

We're running Windows 2000 Server with IIS, php 4.04, and MS SQL db. We run an update with mssql and error out. When we display the result from the udpate we get nothing (empty result), yet the datatbase was updated correctly. We run the same script on NT with php 4.02 and it runs fine (result is 1 and 1 row was updated in the db correctly). After much testing, it seems like a php 4.04 issue. Wondering if anyone else ran into something like this. Thanks for any help.

[coldfusionman]

I am running the same here and have had no troubles. Have you any code you are using and/or the actual error message you get? Thanks...

[Anon]

Thanks for the response. Here's the update code we run after a successful mssql_connect (to load $connection) and mssql_select_db. We run the statement and it dies with the "Couldn't execute query message". When we run the statement from another box (using NT/php4.02) it works.

$sql = "UPDATE users SET first_name = '$first_name', last_name = '$last_name', dept_id = '$dept', reports_to = '$verified_reports_to', title = '$title', email = '$email', hire_date = '$hire_date', birthday ='$birthday', phone_number = '$phone_number', location_id = '$location', travel_switch = '$travel', employment_status = '$employed', reports_to_id = '$reports_to_id' WHERE user_id = '$id'";

$sql_result = mssql_query($sql,$connection) or die ("Couldn't execute query.");