| |
include("include_banner.php");?>
|
 |
 |
 |
 |
$masterkey="student";
include("jadmin/mod_cms/config.php");
$sql_cms ="SELECT ".$mod_tb_root."_id,".$mod_tb_root."_subject ,".$mod_tb_root."_masterkey ,".$mod_tb_root."_title ,".$mod_tb_root."_credate , ".$mod_tb_root."_pic FROM ".$mod_tb_root." WHERE ((".$mod_tb_root."_sdate='0000-00-00 00:00:00' AND ". $mod_tb_root."_edate='0000-00-00 00:00:00') OR (".$mod_tb_root."_sdate='0000-00-00 00:00:00' AND TO_DAYS(".$mod_tb_root."_edate)>=TO_DAYS(NOW()) ) OR (TO_DAYS(".$mod_tb_root."_sdate)<=TO_DAYS(NOW()) AND ". $mod_tb_root."_edate='0000-00-00 00:00:00' ) OR (TO_DAYS(".$mod_tb_root."_sdate)<=TO_DAYS(NOW()) AND TO_DAYS(".$mod_tb_root."_edate)>=TO_DAYS(NOW()) )) AND ".$mod_tb_root."_masterkey='".$masterkey."' AND ".$mod_tb_root."_language='Thai'";
$sql_cms.=" AND ".$mod_tb_root."_status='Pinning' ORDER BY ".$mod_tb_root."_order DESC LIMIT 0,3";
$query_cms=mysql_query($sql_cms);
$index_col=0;
while($row_cms=mysql_fetch_array($query_cms)){
$index_col++;
$txt_cms_id=$row_cms[0];
$txt_cms_subject=rechangeQuot($row_cms[1]);
$txt_cms_key=$row_cms[2];
$txt_cms_detail=rechangeQuot($row_cms[3]);
$txt_cms_deate=ShowDateLongTh($row_cms[4]);
$txt_cms_pic=$mod_path_index_fornt."/".$row_cms[5];
?>
|
| | |