php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #32018 mssql_query() doesnt seem to return a postive result identifier on success
Submitted: 2005-02-18 12:19 UTC Modified: 2005-02-18 13:58 UTC
From: bobpilly at yahoo dot co dot uk Assigned:
Status: Closed Package: MSSQL related
PHP Version: 5.0.3 OS: Fedora Core 3 2.6.10-1.760_FC3
Private report: No CVE-ID: None
 [2005-02-18 12:19 UTC] bobpilly at yahoo dot co dot uk
Description:
------------
I have just upgraded to php 5.0.3 and a simple if statement based on the identifier that worked with php 5.0.2 no longer works. I have now downgraded back to php 5.0.2 and everything is working fine again. when trying a print of $result in 5.0.2 i am returned a '1' character, when trying the same in 5.0.3 the $result variable is empty. 
I have checked the database and the query in running correctly and the field is being updated.
May be a case that the function has changed and its not in the online documentation yet?

Reproduce code:
---------------
$numero= mssql_connect($dbserver,$dbuser,$dbpass)
or die ("Unable to connect to database server");

$query = "update test_table set phonenum = '$phonenum' where ind = '$ind'";
$result = mssql_query($query,$numero);
if($result){
      print "update success!";
}
else{
      print "update failure!";
}

Expected result:
----------------
update success!

Actual result:
--------------
update failure!

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-02-18 13:52 UTC] bobpilly at yahoo dot co dot uk
Hi

Thanks very much this worked with no problems at all.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Dec 26 13:01:30 2024 UTC