By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,949 Members | 1,838 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,949 IT Pros & Developers. It's quick & easy.

grouping output to screen

P: n/a
I'm able to run the following while in php admin, but I want to be able to
run this from a php page and seethe results on the screen. Any suggestions?

SELECT state, count( state ) 'count'
FROM contacts3
GROUP BY state
ORDER BY state LIMIT 0 , 30
Jul 16 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I read about the template tamer at that site.What's throwing me on this is
how to assign count to a variable.

"rush" <pi**@rush.avalon.hr> wrote in message
news:bh**********@ls219.htnet.hr...
"entoone" <en*****@pacbell.net> wrote in message
news:NS***************@newssvr25.news.prodigy.com. ..
I'm able to run the following while in php admin, but I want to be able to run this from a php page and seethe results on the screen. Any

suggestions?

SELECT state, count( state ) 'count'
FROM contacts3
GROUP BY state
ORDER BY state LIMIT 0 , 30


you can take a look at these 2 examples:

http://www.templatetamer.org/index.p...leMySqlRowList
http://www.templatetamer.org/index.php?MySqlRowList

rush
--
http://www.templatetamer.com/

Jul 16 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.