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
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