Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in view_day.php on line 116
오타
[Error]
- Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in 2012.05.17
- [mysql] 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 ~ 2012.05.17 2
- [php] syntax error, unexpected 'EOF' 2012.05.16
- [ERROR]Warning: Wrong parameter count for substr() in 2012.05.15
- [mysql]mysql_fetch_array(): supplied argument is not a valid MySQL result resource in 2012.05.15
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
2012. 5. 17. 09:43
아래로가기
[mysql] 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 ~
2012. 5. 17. 09:40
아래로가기
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
이곳에서 ) 부터 쿼리문이 잘못 되어서 그렇다
'[Error]' 카테고리의 다른 글
[php] syntax error, unexpected 'EOF'
2012. 5. 16. 16:17
아래로가기
} 확인
오타나 빠진 부분이 있는지 확인한다.
'[Error]' 카테고리의 다른 글
[ERROR]Warning: Wrong parameter count for substr() in
2012. 5. 15. 16:35
아래로가기
Warning: Wrong parameter count for substr() in
파라미터 갯수틀릴경우
.substr("0" ,$sMon, strlen($sMon) -1, 2).
.substr("0" .$sMon, strlen($sMon) -1, 2).
빨강색으로 ,(콤마)와 .(점)이 문제였습니다.
'[Error]' 카테고리의 다른 글
[mysql]mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
2012. 5. 15. 16:33