PHP, MySql and count()

admin

Administrator
Staff member
Hi
I am new to PHP and I would like to know how to pass a count() to a table. here is my sql command:$sql = "SELECT Dept,COUNT(Dept) FROM students group by Dept"; I can get it to do a count of all my data but I need it to be displayed in a table and a count by Dept.
any help will be appresiated.
Please email Me: <!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
Thanx
Shaun Fisher
 
Back
Top