첫번째
$query = "SELECT wr_9 FROM `g4_write_KTX` WHERE wr_3='$inDate' and wr_15='$Idcnt' and (wr_4='$intime' or wr_11='$intime' or wr_12='$intime' or wr_13='$intime') ";
두번째
$query = "SELECT wr_9 FROM `g4_write_KTX` WHERE wr_3='$inDate' and wr_15='$Idcnt' and (wr_4 BETWEEN '$intime'AND '$intime3') or (wr_11 BETWEEN '$intime'AND '$intime3') or (wr_12 BETWEEN '$intime'AND '$intime3')or (wr_13 BETWEEN '$intime'AND '$intime3') ";
첫번째는 되는데요 두번째가 안되요
그러니깐 wr_4에 10~13까지의 숫자가 또 wr_11에도 wr_12,13에도 10~13안의 숫자가 들어가면 값 출력! 그렇지 않으면 아무것도 출력 안되게요
이거원...밤샜어요ㅠㅠ
고수님들 도와주세요~
$query = "SELECT wr_9 FROM `g4_write_KTX` WHERE wr_3='$inDate' and wr_15='$Idcnt' and (wr_4='$intime' or wr_11='$intime' or wr_12='$intime' or wr_13='$intime') ";
두번째
$query = "SELECT wr_9 FROM `g4_write_KTX` WHERE wr_3='$inDate' and wr_15='$Idcnt' and (wr_4 BETWEEN '$intime'AND '$intime3') or (wr_11 BETWEEN '$intime'AND '$intime3') or (wr_12 BETWEEN '$intime'AND '$intime3')or (wr_13 BETWEEN '$intime'AND '$intime3') ";
첫번째는 되는데요 두번째가 안되요
그러니깐 wr_4에 10~13까지의 숫자가 또 wr_11에도 wr_12,13에도 10~13안의 숫자가 들어가면 값 출력! 그렇지 않으면 아무것도 출력 안되게요
이거원...밤샜어요ㅠㅠ
고수님들 도와주세요~
|
댓글을 작성하시려면 로그인이 필요합니다.
댓글 2개
설마 이것은 아니겠죠?!
"SELECT wr_9 FROM `g4_write_KTX` WHERE wr_3='$inDate' and wr_15='$Idcnt'
and (
(wr_4 BETWEEN '$intime'AND '$intime3') or (wr_11 BETWEEN '$intime'AND '$intime3')
or
(wr_12 BETWEEN '$intime'AND '$intime3')or (wr_13 BETWEEN '$intime'AND '$intime3') ";
)
??