empty query results

[tito]

I have basically copied that code from a tutorial. Why would it return empty results for $day and $visitors when there are values in db?

$db = mysql_connect("localhost", "root", "root");
mysql_select_db("webstats",$db);
$query = "SELECT * FROM stats";
$result = mysql_query($query,$db);
extract(mysql_fetch_array($query)); {
echo "<set name='$day' value='$visitors' color='FF5904' />";
}

[matto]

extract(mysql_fetch_array($query)); 

should be:

extract(mysql_fetch_array($result)); 

('cause $query is just the sql statement)

[tito]

thank you. I am getting somewhere. Unfortunately, it is displaying only the first row.