How PHP can output tabular content is faster and more efficient.

How PHP can output tabular content is faster and more efficient.

For example, I have the test table now.
There's ID,FENLEI,MC in there.
Represent, ID, auto-grow,
Fenlei, entry area
MC, the specific selection parameters
ID Fenlei MC
1 Beijing Health Good
2 Shanghai Good Health
3 Shanghai Good Service
4 Tianjin Good Health
5 Tianjin Service Good
6 Beijing good service
7 Shanghai Good Health
8 Shanghai Good Service

I want to do a statistic on this form. Use the program to output the following table.

I want to separate statistics

Reply to discussion (solution)

Select A.fenlei, COUNT (*), COUNT (*)/(SELECT COUNT (*) from test) *100 as percentage, Constitutefrom test A, (select Fenlei, Group_concat (MC, ', ', CNT) as constitute from (select Fenlei, MC, COUNT (*) as CNT from test Group by) T-Group by 1) t1whe Re A.fenlei=t1.fenlei GROUP by 1

Database design is too much.

Database design is too much.

What good advice do you have?

What is the abbreviation for MC, name? Position?

------------------------------------------------------autocsdn Signature File------------------------------------------------------

Yard Farm?? Yards farming code, grazing ideas of the farm!

