Re: PHP and MySQL SELECT COUNT (*)
| From: | Micah Gersten | Date: | Wed, 17 Sep 2008 19:32:17 +0000 |
| Subject: | Re: PHP and MySQL SELECT COUNT (*) | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-280393@lists.php.net to get a copy of this message | ||
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
>