php while() loop within if / else not seeming to work

Question

I've been confused about why this wont work! My query executes perfectly fine in all aspects, but when I added the if check on the $row value, the echo message goes as expected (if there are no results), but the else will not kick when there is a match in my query??? Why is this not working? Someone please ease my pain and set me straight!!

$row = mysql_fetch_array($result);
if (!$row) {
    echo "Sorry brah. Nothing matches your search criteria.";
} else {

$i = 1;
while($row = mysql_fetch_array($result)) {
    echo "$i - " . $row['first_name'] . " " .  $row['last_name'] . " - " .   $row['address'] . "<br />";
$i++;
    } 
}

Gaurav · Accepted Answer · 2011-03-27 08:40:07Z

9

$row = mysql_fetch_array($result);  // this fetches the first row your result
...

in while loop you are again fecthing thr row from result. Which will not work if you have only one row in resul

use

if (mysql_num_rows($result) == 0) {
    echo "Sorry brah. Nothing matches your search criteria.";
} else {
    $i = 1;
    while($row = mysql_fetch_array($result)) {
        echo "$i - " . $row['first_name'] . " " .  $row['last_name'] . " - " .   $row['address'] . "<br />";
        $i++;
    } 
}

edited Mar 27, 2011 at 8:40

answered Mar 27, 2011 at 7:44

Gaurav

28.8k9 gold badges54 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Decent Dabbler Over a year ago

I took the liberty of editing your answer. mysql_num_rows($result) > 0, should be mysql_num_rows($result) == 0. Hope you don't mind.

Headshota · Accepted Answer · 2011-03-27 07:46:00Z

3

try mysql_num_rows($result)==0 instead in the if statement

answered Mar 27, 2011 at 7:46

Headshota

21.4k13 gold badges63 silver badges82 bronze badges

Collectives™ on Stack Overflow

php while() loop within if / else not seeming to work

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related