3.0.12: mysql_store_result in php3_mysql_query
| From: | (David Sklar) | Date: | Thu, 02 Sep 1999 21:27:13 +0000 |
| Subject: | 3.0.12: mysql_store_result in php3_mysql_query | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-10472@lists.php.net to get a copy of this message | ||
I have a page that does:
$r = mysql_query('select ping from ping');
if ($r) {
if ($ob = mysql_fetch_object($r)) {
echo $ob->ping."\n";
} else {
echo "Can't get ob\n";
}
} else {
echo "Can't do query\n";
}
Very infrequently, when accessing this page, I get a "PHP 3 Warning: 1 is not
a MySQL result index" at the line with mysql_fetch_object(). So mysql_query is
returning 1 (or TRUE that gets evaluated to 1?) but it's still not really a
result handle.
Could the following code in php3_mysql_query() be responsible: ?
if ((mysql_result=mysql_store_result(mysql))==NULL) {
/*php3_error(E_WARNING,"Unable to save MySQL query result");
RETURN_FALSE;
*/
RETURN_TRUE;
}
Why is it returning true if there was an error? mysql_store_result() returns
NULL if an error occurs.
-dave