1 query, 2 different results

[sophistikat]

I am stuck and probably should put this away for a bit and then come back to it but I have my moments of stubbornness.

In phpMyAdmin, this return 5 rows of data

SELECT * FROM health_stats

In my PHP file, this return only 1 row; the first row

#get stats name first
$this->query = "SELECT * FROM health_stats";
$this->db->runQuery($this->query);
$qresults = $this->db->getQueryResults();
$health_stats = mysql_fetch_array($qresults, MYSQL_ASSOC);
print_r($health_stats);

[johanafm]

# get next row until end of data
while ($health_stats = mysql_fetch_array($qresults, MYSQL_ASSOC))
{
    print_r($health_stats);

[/QUOTE]
}[/code]

[sneakyimp]

Read the examples on [man]mysql_fetch_array[/man]. It's meant to be called repeatedly on the result of a query.