메인페이지 최하단 에러가 뜨네요..
본문
select * from where po_start_date < '2015-10-11 16:52:46' and po_end_date > '2015-10-11 16:52:46' and po_openchk = '1'
1064 : 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 'where po_start_date < '2015-10-11 16:52:46' and po_end_date > '2015-10-11 16:52:' at line 1
error file : /main.php
이런에러가 메인페이지 최 하단에 뜨는데..... 무슨 에러인가요?
메인페이지 소스는요
<script type="text/javascript">
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-16769464-1']);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
</script>
<?
include_once("./_common.php");
include_once("$g4[path]/lib/latest.lib.php");
$main_page = "1";
$g4['title'] = "";
include_once("./_head.php");
echo latest("basic", "photo", 7, 70);
echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>\n";
include_once("./_tail.php");
?>
답변 1
쿼리상으로는 테이블명이 없네요.
include_once("./_tail.php"); 이 소스를 살펴보세요
select * from where po_start_date < '2015-10-11 16:52:46' and po_end_date > '2015-10-11 16:52:46' and po_openchk = '1'
select * from 테이블명 where po_start_date < '2015-10-11 16:52:46' and po_end_date > '2015-10-11 16:52:46' and po_openchk = '1'
답변을 작성하시기 전에 로그인 해주세요.