The sum (case when illreport. Class_e='1' seven then 1 else 0 end) as t1,
The sum (case when illreport. Class_e='7' 2 then one else 0 end) as t1
The from illreport
Group by illreport. Tj_time
Where illreport. Tj_time=the date ()
Description:
Fields:
Tj_time field is the date of the submitted reports;
Class_e field is the name of the class;
Illreport is form;
Design purpose: to find out the current date, submit the number of times in each class, the number is assigned to class 1, seven t1; The seven 2 class is assigned to the number of t2... So on, and then want to call in the web page display t1, t2...
