using mysqli::fetch_array but only getting 2 of the items?

Question

Ive got a database that Im trying to pull data from (the name of each unique identifier and also how many times it appears in the database) by using this query:

$query = "SELECT Dcol, COUNT(*) FROM dtest GROUP BY Dcol";

and then using this to actually print the data out:

while($result->fetch_row()){

$row = $result->fetch_array(MYSQLI_NUM);
printf("<strong>%s</strong> : <i>%s</i><br />",$row[0],$row[1]);

}

and it works great except for the fact that it only gets 2 of the 4 unique items from the Dcol column. I've tested it by just putting everything that the fetch_row() returns into an array and then using print_r and when I do that it actually shows all 4 with the correct number of times it was used, but when I try to print it using the above statement I get 2 of the 4 (the second and fourth one, if that helps at all)

Can anyone tell me why this would only be giving two of the four unique items?

ethrbunny · Accepted Answer · 2013-01-07 17:22:24Z

1

The 'fetch_row' command is getting the first row - then you ask for the 2nd row with the 'fetch_array' command. So you're only seeing 2 and 4 as a result.

answered Jan 7, 2013 at 17:22

ethrbunny

10.5k9 gold badges77 silver badges145 bronze badges

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

Collectives™ on Stack Overflow

using mysqli::fetch_array but only getting 2 of the items?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related