query($q1) or die(mysql_error());
?>
fetch_object()){ ?>
-
=date_add('$datenow',interval -7 day) AND video_source != '' ";
$qr1=$mysqli->query($q1) or die(mysqli_error());
$rs1=$qr1->fetch_object();
$num_new =$rs1->num_new;
$q2="SELECT count(*) as num_new FROM cddtube_data WHERE video_cat='1' AND video_source != '' ";
$qr2=$mysqli->query($q2) or die(mysqli_error());
$rs2=$qr2->fetch_object();
$num_cat1 =$rs2->num_new;
$q3="SELECT count(*) as num_new FROM cddtube_data WHERE video_cat='2' AND video_source != '' ";
$qr3=$mysqli->query($q3) or die(mysqli_error());
$rs3=$qr3->fetch_object();
$num_cat2 =$rs3->num_new;
$q4="SELECT count(*) as num_new FROM cddtube_data WHERE video_cat='3' AND video_source != '' ";
$qr4=$mysqli->query($q4) or die(mysqli_error());
$rs4=$qr4->fetch_object();
$num_cat3 =$rs4->num_new;
$q5="SELECT count(*) as num_new FROM cddtube_data WHERE video_cat='4' AND video_source != '' ";
$qr5=$mysqli->query($q5) or die(mysqli_error());
$rs5=$qr5->fetch_object();
$num_cat4 =$rs5->num_new;
$q6="SELECT count(*) as num_new FROM cddtube_data WHERE video_cat='5' AND video_source != '' ";
$qr6=$mysqli->query($q6) or die(mysqli_error());
$rs6=$qr6->fetch_object();
$num_cat5 =$rs6->num_new;
$num_sum = $num_cat1+$num_cat2+$num_cat3+$num_cat4+$num_cat5;
?>
วีดีโอมาใหม่ 
วีดีโอการประชุมกรม 
วีดีโอชี้แจงส่วนภูมิภาค
วีดีโอส่วนภูมิภาค
วีดีโอประชาสัมพันธ์ อบรม สื่อการสอน
วีดีโออื่นๆ 
วีดีโอทั้งหมด