php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #60251 mysql_fetch_row bad return value on error
Submitted: 2011-11-09 15:03 UTC Modified: 2011-11-10 18:07 UTC
From: richard dot gavenda at gmail dot com Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 5.3.8 OS: Windows
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: richard dot gavenda at gmail dot com
New email:
PHP Version: OS:

 

 [2011-11-09 15:03 UTC] richard dot gavenda at gmail dot com
Description:
------------
When $result parameter of mysql_fetch_row isn't resource, mysql_fetch_row returns NULL instead of FALSE.

This code:

while (($data = mysql_fetch_row($result)) !== false) {
   ...
}

gets in infinite loop

Test script:
---------------
$result = mysql_query("BAD SQL SYNTAX OR CONNECTION PROBLEM"); 
// $result value is now FALSE

$data = mysql_fetch_row($result);
var_dump($data);

Expected result:
----------------
bool(false)

Actual result:
--------------
NULL

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2011-11-10 18:07 UTC] johannes@php.net
-Status: Open +Status: Bogus
 [2011-11-10 18:07 UTC] johannes@php.net
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to report
a bug at http://bugs.php.net/how-to-report.php

See note in http://php.net/functions.internal
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Thu Jan 02 12:01:29 2025 UTC