grouping output to screen

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

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

"rush" <pipa@rush.avalon.hr> wrote in message
news:bhae0b$s3l$1@ls219.htnet.hr...
> "entoone" <entoone@pacbell.net> wrote in message
> news:NSVZa.627$S65.387@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/
>
>
>