php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #20222 mssql_free_result():
Submitted: 2002-11-02 13:46 UTC Modified: 2002-11-03 08:45 UTC
From: boccara at netvision dot net dot il Assigned:
Status: Not a bug Package: MSSQL related
PHP Version: 4.2.3 OS: win 2k server SBS
Private report: No CVE-ID: None
 [2002-11-02 13:46 UTC] boccara at netvision dot net dot il
I 've got this warning for a query that works, I don't understand why.
PHP Warning: mssql_free_result(): 18 is not a valid MS SQL-result resource in ...
here the code: 
$strSQL  = " SELECT REF_PRODUIT FROM PRODUITS WHERE ACTUEL = 1 AND REF_EDITEUR = '$pEditeur' AND REF_PRODUIT ='".$tabCol[0]."'";	
$iQuery2 = dbQuery($iConnect, $strSQL) ;
echo $iQuery2;
dbFetch($iQuery2, $tabref);
dbFreeResult($iQuery2);

here the echo of iQuery2:
Resource id #9 
Resource id #12 
Resource id #15 
Resource id #18


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-11-02 14:23 UTC] kalowsky@php.net
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PHP.


Can you give us the full error message as well?
 [2002-11-03 06:52 UTC] boccara at netvision dot net dot il
here is the full error message:
PHP Warning: mssql_free_result(): 18 is not a valid MS SQL-result resource in D:\Inetpub\d2b_devis\lib\dbutils.inc.php on line 335 

here is the code on line 335:
/* 334 */case "MSSQL":
/* 335 */mssql_free_result($iResult);
/* 336 */break;

I don't understand why it works for ressource number 9,12 & 15, and for ressource number 18 I.ve got an error message.
I've got also the same error message at different part of my program but with a different ressource number.
For me it really seems to be link with PHP and not with somthing else.
I hope I could help in the developpment of PHP,
best regards.
 [2002-11-03 08:45 UTC] kalowsky@php.net
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PHP.


From that error I get the impression that one of your queries did not succeed.  Please break this down to a simple script to reproduce this, and it will make debugging this a lot easier.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Mar 28 22:01:26 2024 UTC