sql_query() 구한 값 합치는 방법이 있을까요?
$out_hos_re_26 = sql_query("select * from g4_write_membership where (wr_1 between '00000000' and '$to_date') AND wr_26 = $to_date");
$out_hos_re_30 = sql_query("select * from g4_write_membership where (wr_1 between '00000000' and '$to_date') AND wr_30 = $to_date");
$out_hos_re_33 = sql_query("select * from g4_write_membership where (wr_1 between '00000000' and '$to_date') AND wr_33 = $to_date");
3개의 쿼리문으로 구한 데이터를 하나로 합치려고 아래 처럼 했는데 안되네요..
$result = array($out_hos_re_26 + $out_hos_re_30 + $out_hos_re_33);
for ($i=0; $row=sql_fetch_array($result); $i++) {
echo $row[wr_subject];
}
array 말고 join , array_merge 사용해도 안되네요...
방법이 있을까요???
$out_hos_re_30 = sql_query("select * from g4_write_membership where (wr_1 between '00000000' and '$to_date') AND wr_30 = $to_date");
$out_hos_re_33 = sql_query("select * from g4_write_membership where (wr_1 between '00000000' and '$to_date') AND wr_33 = $to_date");
3개의 쿼리문으로 구한 데이터를 하나로 합치려고 아래 처럼 했는데 안되네요..
$result = array($out_hos_re_26 + $out_hos_re_30 + $out_hos_re_33);
for ($i=0; $row=sql_fetch_array($result); $i++) {
echo $row[wr_subject];
}
array 말고 join , array_merge 사용해도 안되네요...
방법이 있을까요???
|
댓글을 작성하시려면 로그인이 필요합니다.
댓글 3개
union 또는 union all 로 처리하면 되는군요...
$out_hos_re_26 = sql_query("select * from g4_write_membership where (wr_1 between '00000000' and '$to_date') AND wr_26 = $to_date
union all
select * from g4_write_membership where (wr_1 between '00000000' and '$to_date') AND wr_30 = $to_date
union all
select * from g4_write_membership where (wr_1 between '00000000' and '$to_date') AND wr_33 = $to_date");
이리하면 되는군요 ,....^^;;;