You'll want to change your Order By statement to 'ORDER BY CountSteps DESC'. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gullotta wrote: > echo $query; > > yields > > SELECT servername, COUNT(steps) as CountSteps FROM monitoring WHERE > steps = 'IISRESET' AND timestamp <= '2008-09-17 11:40:34' AND > timestamp >= '2008-08-17' GROUP BY servername ORDER BY COUNT(*) DESC > LIMIT 10 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
