Query sort by oldest first ?

[thefollower]

How do you sort a query result by oldest first?

 

I got this query:

$GetReports = mysql_query("SELECT * FROM reportedusers
                    WHERE StaffRead='0'")
			or die(mysql_error());

And i have an additional filed which is:

TimeReported in this format : date("Y-m-d H:i:s",time());

 

And i wanted the query to make sure the oldest row was the first one to come out when fetch_assoc function occurred...is that possible?

 

 

[zq29]

SELECT * FROM `reportedusers` WHERE `StaffRead`='0' ORDER BY `TimeReported` ASC