GROUP BY句子 :
$query =
" SELECT SCHOOL_ITEM , IDENTITY , COUNT( * ) as TOTAL_COUNT FROM student
where
(SET_TIME between '" . $_POST['form_year'] . "-" . $_POST['form_month'] . "-" . $_POST['form_day'] . "' and '" . $_POST['end_year'] . "-" . $_POST['end_month'] . "-" . $_POST['end_day'] . "')
GROUP BY SCHOOL_ITEM
ORDER BY SCHOOL_ITEM " ;
LIKE :
LIKE '%".$keywords."%'
$query =
" SELECT SCHOOL_ITEM , IDENTITY , COUNT( * ) as TOTAL_COUNT FROM student
where
(SET_TIME between '" . $_POST['form_year'] . "-" . $_POST['form_month'] . "-" . $_POST['form_day'] . "' and '" . $_POST['end_year'] . "-" . $_POST['end_month'] . "-" . $_POST['end_day'] . "')
GROUP BY SCHOOL_ITEM
ORDER BY SCHOOL_ITEM " ;
LIKE :
LIKE '%".$keywords."%'
沒有留言:
張貼留言
若你看的文章，時間太久遠的問題就別問了，因為我應該也忘了... XD