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]