게시판에서 내가 작성한 글들을 불러오려고 쿼리를 찾다가 union을 사용했습니다.

게시판정보 테이블에서 게시판 이름을 가져와서 for문 돌려서 게시판에 있는

게시글 숫자를 다 합치는 쿼리를 만들었습니다.

select sum(all_count.cnt) AS all_counts

from (

SELECT count(*) cnt from `g5_write_email` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_notice` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_bodo` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_review` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_snsphoto` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_snsvideo` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_report` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_magazine` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_tv` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_bfood` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_page` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_food` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_event` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_inquiry` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_pubandpop` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_wbodo` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_foodstory` where mb_id = 'ri1205'

union all SELECT count(*) cnt from `g5_write_companypoto` where mb_id = 'ri1205'

) all_count

위 쿼리를 만들어서 바로 sql에 실행을 하면

위처럼 결과가 나옵니다.

근데 php페이지에서

$all_row = sql_fetch($all_query);

$total_count = $row['all_counts'];

echo $all_query;해서 값을 확인하면 값이 안나오고 있어요...

혹시나해서 print_r($all_row)배열로 확인하면 Array ( [1] => 1 ) 라고만 나와요;;;

어디가 문젠지 모르겠어요;;쿼리는 실행이 되서요 ㅠㅠ