I am having a little trouble figuring out the COUNT function in PHP and MYSQL... I am new to both. The table I am using is "students" and the colum is "Called_Received" in the colum is just a 1 or 0 for yes/no... I am trying to use the SELECT and COUNT to get three numbers:
Total=? Yes=? No=?
I want the labels to be: "Total", "OK", "NA"
someone pointed me in the direction of this:
SELECT Called_Received COUNT "*", COUNT "Called_Received=1", COUNT "Called_Received=0" FROM students
This of course does not work. I was told this is a simple function but I'm just having a hard time with it. I would really appciate it if someone could help me out with this SQL statement. Hopefully I described this well enough.