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