grouping output to screen

[entoone]

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

[entoone]

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/