Why does my code only return every second result in php mysql?

Question

I have been writing some code which pulls entries from a MySQL database. These are numbers 1 to 38

However, it only returns every second number i.e. 2,4,6,8 instead of 1,2,3,4.

$result = mysql_query("select (caseID) FROM `case` order by caseID")
 or die(mysql_error());  

while(mysql_fetch_array( $result )) 
{ 
    $row = mysql_fetch_assoc($result); 
    $countName= $row['caseID'];

    Print $countName;
}

I've tried various changes and reducing the code to the bare minimum. But nothing seems to work.

Heads up! The next major release of PHP is deprecating the mysql_ family of functions. Now would be a great time to switch to PDO or mysqli. — Charles
– Charles, Commented Jan 7, 2013 at 10:06

Hanky Panky · Accepted Answer · 2013-01-07 09:27:08Z

6

Calling mysql_fetch_array two times, thats why.

Try this

while($row=mysql_fetch_assoc( $result )) 
{ 
$countName= $row['caseID'];
 print $countName;
}

answered Jan 7, 2013 at 9:27

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

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

1 Comment

blarg Over a year ago

Huh? What do you mean by that?

Sverri M. Olsen · Accepted Answer · 2013-01-07 09:30:53Z

0

It is because you are calling mysql_fetch_array, which retrieves one result, and then you call mysql_fetch_assoc, which retrieves yet another result. That is then repeated until there are no more results left.

Or, in other words, you are fetching one result without using it, and then fetching another result which is then used, effectively jumping over every other result.

This should do the job:

while($row = mysql_fetch_assoc($result)) 
{ 
    print $row['caseID'];
}

Also, take a look at the documentation. Turn your eyes to the big box that says "Warning" and has a stop sign in it.

answered Jan 7, 2013 at 9:30

Sverri M. Olsen

13.2k3 gold badges38 silver badges54 bronze badges

Collectives™ on Stack Overflow

Why does my code only return every second result in php mysql?

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