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]

Re: grouping output to screen

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.aval on.hr> wrote in message
news:bhae0b$s3l $1@ls219.htnet. hr...[color=blue]
> "entoone" <entoone@pacbel l.net> wrote in message
> news:NSVZa.627$ S65.387@newssvr 25.news.prodigy .com...[color=green]
> > I'm able to run the following while in php admin, but I want to be able[/color][/color]
to[color=blue][color=green]
> > run this from a php page and seethe results on the screen. Any[/color]
> suggestions?[color=green]
> >
> > SELECT state, count( state ) 'count'
> > FROM contacts3
> > GROUP BY state
> > ORDER BY state LIMIT 0 , 30[/color]
>
> 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/
>
>
>[/color]