Why are three statistics displayed ...... Omitted & lt ;! -- & Nbsp; subject: start & nbsp; -- & gt; & nbsp; & lt ;? Php & nbsp; $ SQL & nbsp; select & nbsp; kemu_id, name & nbsp; from & nbsp ;. $ fdyu-& gt; Why are three ta statistics displayed?
...... Omitted
$ SQL = "select kemu_id, name from ". $ fdyu-> table ('oa _ kemu '). "where school_id = ". $ school_id. "and parent_id = 0 order by kemu_id asc ";
$ Res = $ db-> query ($ SQL );
If ($ res)
{
While ($ row = $ db-> fetchRow ($ res ))
{
?>
// Student statistics by subject
Foreach ($ arr_date as $ val)
{
$ SQL _new = "select count (*) from". $ fdyu-> table ('oa _ xueyuan ').
"As xy left join ". $ fdyu-> table ('oa _ banji '). "as bj on xy. cur_banji_id = bj. banji_id ". $ SQL _where_ B. "and bj. kemu_1 = ". $ row ['kenu _ id'];
Echo '('. $ db-> getOne ($ SQL _new ). ')'; // why is it displayed here (60) (60) (60 ).. why is it repeated twice ?}
?>
...... Omitted
------ Solution --------------------
Yes, I'm welcome.
------ Solution --------------------
It's very big to compete with the moderator.
------ Solution --------------------