[thelist] PHP, MySQL - category counter puzzle

Algian algian at algian.com
Mon May 28 09:06:22 CDT 2001


Hello,
I think you could query the database using

sql>select count(column_name) from table_name where categorie='cat_name';

count counts the number of rows in the that column (excluding null) so if it
returns
0 then there is no products otherwise there is...
Does this help?

Ale

/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\/|\
Alessandro Giannone
Web Anomaly Creator
Edinburgh University
Department of Science & Engineering
\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/\|/





More information about the thelist mailing list