[PHP-DEV] PHP 4.0 Bug #7548: Database links and result sets seem to not be properly returned. From: tonym <email protected>
Date: 10/31/00

From: tonym <email protected>
Operating system: RedHat 7
PHP version: 4.0.3pl1
PHP Bug Type: MySQL related
Bug description: Database links and result sets seem to not be properly returned.

Database links and result sets seem to not be properly returned.

Heavily edited script:

$db = mysql_pconnect("server","user","pw") || die "Couldn't connect to db!";
  // or, $db = mysql_connect( ... )

// the following works:
$result = mysql_list_dbs();
$x = mysql_num_rows( $result );
for ($i = 0; $i < x; $i++) {
  echo "table found: " . mysql_table_name($result, $i) . "<br>";
}

// the following does not:
$result = mysql_list_dbs( $db ); // give warning "not a valid MySQL link"
$x = mysql_num_rows( $result ); // give warning "not a valid MySQL result resource"

// the following works:
$result = mysql_query("INSERT INTO users (id, name) VALUES (10, 'fred')");

// the following does not:
$result = mysql_query("SELECT name FROM users")
    || die (Query failed); // die() not called
while ($row = mysql_fetch_row( $result )) { // give warning "not a valid MySQL result resource"
    <do something> // this line is never reached
}

// the following also does not work:
$result = mysql_query("SELECT 1 + 1 as total")
    || die (Query failed); // die() not called
$total = mysql_fetch_row( $result ); // give warning "not a valid MySQL result resource"

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

Compile options:
  --with-apxs=/usr/local/apache/bin/apxs
  --with-mysql=/usr/local/mysql
  --enable-track-vars

MySQL version 3.23.27-beta 

-- 
Edit Bug report at: http://bugs.php.net/?id=7548&edit=1

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>