Re: [PHP-DB] counting categories

2001-10-28 Thread Frank M. Kromann
Hi, Depending on the database you are selecting from you could do it in one select like this: select category, count(*) from $table group by category order by category; - Frank > How would you get the count of each category? > > Like this - http://www.scriptsearch.com > > Would you have to

[PHP-DB] counting categories

2001-10-28 Thread olinux
How would you get the count of each category? Like this - http://www.scriptsearch.com Would you have to run a different select for each one? or would you do something like "select category from $table " and then count all of the matches for each category "perl" "php" "asp" thanks much, Josh