By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

MS-SQL problem after upgrade to 4.3.10

P: n/a
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

Jul 17 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
post the code and let's have a look

Jul 17 '05 #2

P: n/a

"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?
Jul 17 '05 #3

P: n/a
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>';

Jul 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.