Re: PHP and MySQL SELECT COUNT (*)
| From: | Vinny Gullotta | Date: | Wed, 17 Sep 2008 19:54:35 +0000 |
| Subject: | Re: PHP and MySQL SELECT COUNT (*) | ||
| References: | 1 2 3 4 5 6 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-280398@lists.php.net to get a copy of this message | ||
Still no luck displaying the stupid servername. Any other things I can try?
"Micah Gersten" <micah@onshore.com> wrote in message news:48D15B41.8010208@onshore.com...
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