Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

print out group by result

May 4, 2002, 6:45 PM
courierb
User (344 posts)
courierb's avatar
May 4, 2002, 6:45 PM
Views: 5065
Shortcut
Quote Reply
print out group by result
In command line below code works ok.

mysql> SELECT studentstatus, COUNT(*)FROM studentdb GROUP BY studentstatus;

the result wil be :

status1 20

status2 40

status3 18



My question is how to make these value print out in webpage. any code could be used?

I could not know how to handle COUNT(*) value.



Thanks
Subject Author Views Date
Thread print out group by result courierb 5065 May 4, 2002, 6:45 PM
Thread Re: [courierb] print out group by result 		sponge 4892 May 4, 2002, 9:43 PM
Post Re: [sponge] print out group by result 		courierb 4855 May 5, 2002, 3:56 AM