session_start(); include "sql.php"; $id=$_GET['id']; $sql_now = "SELECT * FROM tbl_journal WHERE cat_id = '20150708123431114' AND status = 1 ORDER BY publish_date desc limit 1"; $re_now = mysql_query($sql_now); $sql_dusita = "SELECT * FROM tbl_journal WHERE cat_id = '20150624133051833' AND status = 1 ORDER BY publish_date desc limit 1"; $re_dusita = mysql_query($sql_dusita); $sql_movie = "SELECT * FROM tbl_news WHERE newscat_id = 20140506140923687 AND status = 1 ORDER BY publish_date desc limit 1"; $re_movie = mysql_query($sql_movie); $sql_more = "SELECT * FROM tbl_clips WHERE clips_id != '$id' AND status = 1 ORDER BY create_date desc limit 4"; $re_more = mysql_query($sql_more); $sql_clips = "SELECT * FROM tbl_clips WHERE clips_id = '$id'"; $re_clips = mysql_query($sql_clips); $clips=0; while($rs_clips = mysql_fetch_array($re_clips)){ $title = $rs_clips['clips_name_th']; $video = $rs_clips['clips_vdo']; $date_clips = $rs_clips['create_date']; $clips++; } ?>
แสดงความคิดเห็น