MS-SQL problem after upgrade to 4.3.10

[Kulnor]

My hosting company upgraded yesterday to pHp 4.3.10. Since then, all my
INSERT/UPDATE/DELET query on our MS-SQL database seem to fail. No
specific error message is returned by mssql_get_last_message(). The
SELECT statements work fine.
If I test on my local server running 4.3.9 the application behaves
properly. Any suggestion/idea?
thanks

[EnglishMan]

post the code and let's have a look

[Chung Leong]

"Kulnor" <pa****@mail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

My hosting company upgraded yesterday to pHp 4.3.10. Since then, all my
INSERT/UPDATE/DELET query on our MS-SQL database seem to fail. No
specific error message is returned by mssql_get_last_message(). The
SELECT statements work fine.
If I test on my local server running 4.3.9 the application behaves
properly. Any suggestion/idea?
thanks

Windows or *nix?

[Kulnor]

after further looking at the problem, the query executes properly but
the mssql_query() function always returns FALSE, even on success.
This is with IIS4 and pHp 4.3.10
Sample dummy code below always indicates failure but the user record is
properly updated:

// SELECT A SPECIFIC USER IN THE TABLE
echo '<br>USER NAME BEFORE UPDATE<br>';
$query="SELECT * FROM tb_User WHERE ID='jdoe'";
echo "Executing query: $query<br>";
$rs = mssql_query($query) ;
while($row=mssql_fetch_array($rs)) echo "Name=".$row['Name']."<br>";

// UPDATE THE USER NAME
echo '<br>SET USER NAME TO CURRENT DATE AND TIME<br>';
$name=date("r");
$query="UPDATE tb_user SET name='$name' WHERE ID='jdoe'";
echo "Executing query: $query<br>";
if(mssql_query($query)) echo "Success<br>";
else echo "Failure<br>";

// SELECT SPECIFIC USER AFTER UPDATE
echo '<br>USER NAME AFTER UPDATE<br>';
$query="SELECT * FROM tb_User WHERE ID='jdoe'";
echo "Executing query: $query<br>";
$rs = mssql_query($query) ;
while($row=mssql_fetch_array($rs)) echo "Name=".$row['Name']."<br>";

echo 'The query executes properly but mssql_query does not return
true....<BR>';