이전 목록 다음

메인페이지 최하단 에러가 뜨네요..

2015-10-11 (일) 16:56:17 6,247

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

이런에러가 메인페이지 최 하단에 뜨는데..... 무슨 에러인가요?

메인페이지 소스는요

Copy
<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'

답변을 작성하려면 로그인이 필요합니다.