Do var_dump($i) in the loop to see if you're getting the data you want. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gullotta wrote: > Still no luck displaying the stupid servername. Any other things I can > try? > > > "Micah Gersten" <micah@xxxxxxxxxxx> wrote in message > news:48D15B41.8010208@xxxxxxxxxxxxxx >> 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
