Re: PHP and MySQL SELECT COUNT (*)
| From: | Vinny Gullotta | Date: | Wed, 17 Sep 2008 20:30:21 +0000 |
| Subject: | Re: PHP and MySQL SELECT COUNT (*) | ||
| References: | 1 2 3 4 5 6 7 8 9 10 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-280407@lists.php.net to get a copy of this message | ||
var_dump looks like this:
array(2) { [0]=> string(9) "wehost006" [1]=> string(2) "72" } array(2) { [0]=> string(8) "H7848-49" [1]=> string(2) "71" } array(2) { [0]=> string(7) "H7853-2" [1]=> string(2) "70" } array(2) { [0]=> string(7) "H7842-2" [1]=> string(2) "64" } array(2) { [0]=> string(9) "WEHOST005" [1]=> string(2) "64" } array(2) { [0]=> string(7) "h7835-2" [1]=> string(2) "57" } array(2) { [0]=> string(9) "wehost007" [1]=> string(2) "56" } array(2) { [0]=> string(7) "H7814-1" [1]=> string(2) "55" } array(2) { [0]=> string(5) "H0542" [1]=> string(2) "54" } array(2) { [0]=> string(8) "H7811-12" [1]=> string(2) "54" }
""Dan Joseph"" <dmjoseph@gmail.com> wrote in message news:a20394490809171327sc1ad6bdnd0feaef5b837958c@mail.gmail.com...
On Wed, Sep 17, 2008 at 4:21 PM, Vinny Gullotta <vgullotta@intermedia.net>wrote:var_dump($i); looks messy, but I can see the server names in there and they are the correct names. "Micah Gersten" <micah@onshore.com> wrote in message news:48D1629D.3040801@onshore.com... Do var_dump($i) in the loop to see if you're getting the data you want.Can you show us one of the var_dumps? -- -Dan Joseph www.canishosting.com - Plans start @ $1.99/month. "Build a man a fire, and he will be warm for the rest of the day. Light a man on fire, and will be warm for the rest of his life."Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gullotta wrote:-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.phpStill 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