반응형
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from schedule_table where DATE_FORMAT(rtime, '%Y-%c-%e') = '--'' at line 2
여긴
$query = " select id, subject, DATE_FORMAT(rtime, '%k') as rhour,
description, recordtype, completed, from schedule_table
where DATE_FORMAT(rtime, '%Y-%c-%e') = '$sYear-$sMon-$sDay' ";
이곳에서 ,이 잘못 들어가서 에러가났다.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and A.intRequest_de=1 order by A.intNum desc' at line 1
이곳에서 ) 부터 쿼리문이 잘못 되어서 그렇다
반응형