|  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
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);
      print "update success!";
      print "update failure!";

Expected result:
update success!

Actual result:
update failure!


Add a Patch

Pull Requests

Add a Pull Request


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

Thanks very much this worked with no problems at all.
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun Jul 14 08:01:28 2024 UTC