include "../inc/title.php"; if(!$page) $page = 1; $limit = 16; $offset = ($page-1) * $limit; $ORDERBY = "c_key DESC"; $que = "SELECT content.c_key, content.c_title, content.c_regtime, content.c_date, ch_pastor.cp_name, ch_pastor.cp_pre, church.ch_id, church.ch_name, content.views, content.thumb, content.c_dur FROM public.content, public.ch_pastor, public.church WHERE content.cp_key = ch_pastor.cp_key AND ch_pastor.ch_id = church.ch_id AND content.tp_key = $tp_key AND church.ch_id != 'bc' AND content.thumb IS NOT NULL $WHERE ORDER BY $ORDERBY LIMIT $limit OFFSET $offset "; $res = $db->query($que); $total2 = $db->getOne("SELECT COUNT(*) FROM public.content, public.ch_pastor, public.church WHERE content.cp_key = ch_pastor.cp_key AND ch_pastor.ch_id = church.ch_id AND content.tp_key = $tp_key AND church.ch_id != 'bc' AND content.thumb IS NOT NULL $WHERE"); switch($tp_key) { case "1" : $list_title = "말씀영상"; break; case "2" : $list_title = "찬양영상"; break; case "4" : $list_title = "교육영상"; break; case "6" : $list_title = "홍보영상"; break; default : $list_title = "쉐마TV 영상목록"; } ?>
Notice: Undefined variable: list_title in /home/shematv/www/tv/index.php on line 95
전체
Notice: Undefined variable: total2 in /home/shematv/www/tv/index.php on line 122
0개 영상