write_update 에서 db 검색할때 이거 맞나요? 정보
write_update 에서 db 검색할때 이거 맞나요?
본문
첫번째
$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안의 숫자가 들어가면 값 출력! 그렇지 않으면 아무것도 출력 안되게요
이거원...밤샜어요ㅠㅠ
고수님들 도와주세요~
댓글 전체
'$intime'AND => '$intime' AND
설마 이것은 아니겠죠?!
설마 이것은 아니겠죠?!
$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') ";
)
??
"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') ";
)
??