ID: 11489
Updated by: joey
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Feedback
Bug Type: Sybase-ct (ctlib) related
Operating system: 
PHP Version: 4.0.5
Assigned To: 
Comments:

Cannot reproduce with CVS.

Previous Comments:
---------------------------------------------------------------------------

[2001-06-14 10:15:16] [EMAIL PROTECTED]
The following script produces the following error the second time 
getAppName/sybase_fetch_row is called.

Error (warning):

   /users/pmoosman/test_data/test1.php(26) : Warning - 3 is not a valid Sybase result 
resource

Script:

<?php

function getConnect()
{
  $db = sybase_connect('xxxx','yyy','zzz');
  return $db;
}


function getAppName($app_id) 
{

  // static $db;

  $sql = "select name from web_apps where application_id=$app_id";

  $db = getconnect();

  $result = sybase_query($sql, $db);

  $row = sybase_fetch_row($result);     

  // sybase_free_result($result);
                
  return $row[0];
}

getAppName(23);
getAppName(23);

?>


Note: If I uncomment the "static $db" line, the error (warning) goes away.



I ran PHP in a debugger and it looks like the sybase connection is getting destructed 
when the sybase_query results are getting assigned to "$result".



---------------------------------------------------------------------------



ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=11489&edit=2


-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to