$path1 = "files/news/";
$sql1 = "SELECT * FROM m_news where news_status=1 order by news_date desc LIMIT 6";
$rs1 = $conn->Execute($sql1);
while (!$rs1->EOF) {
$news_id =$rs1->fields["news_id"];
$news_title_th =$rs1->fields["news_title_th"];
$news_title_en =$rs1->fields["news_title_en"];
$news_text_th =$rs1->fields["news_text_th"];
$news_text_en =$rs1->fields["news_text_en"];
$news_date =$rs1->fields["news_date"];
$news_pic =$rs1->fields["news_pic"];
$news_status =$rs1->fields["news_status"];
$news_add =$rs1->fields["news_add"];
$news_update =$rs1->fields["news_update"];
if($news_pic!=""){
$news_pic_p = $path1.$news_pic;
}
?>
$i1++;
if(($i1%3)==0){
echo "";
}
$rs1->MoveNext();
}
?>
$path2 = "files/gallery2/";
$sql2 = "SELECT * FROM m_gallery2_album where gallery2_album_status=1 order by gallery2_album_add desc LIMIT 6";
$rs2 = $conn->Execute($sql2);
while (!$rs2->EOF) {
$gallery2_album_id =$rs2->fields["gallery2_album_id"];
$gallery2_album_pic =$rs2->fields["gallery2_album_pic"];
$gallery2_album_title_th =$rs2->fields["gallery2_album_title_th"];
$gallery2_album_title_en = $rs2->fields["gallery2_album_title_en"];
$gallery2_album_desc_th = $rs2->fields["gallery2_album_desc_th"];
$gallery2_album_desc_en = $rs2->fields["gallery2_album_desc_en"];
$gallery2_album_status =$rs2->fields["gallery2_album_status"];
$gallery2_album_add =$rs2->fields["gallery2_album_add"];
$gallery2_album_update =$rs2->fields["gallery2_album_update"];
if($gallery2_album_pic!=""){
$gallery2_album_pic_p = $path2.$gallery2_album_pic;
}
?>
$i2++;
if(($i2%3)==0){
echo "";
}
$rs2->MoveNext();
}
?>
$path3 = "files/r_news/";
$sql3 = "SELECT * FROM r_news where news_status=1 order by news_date desc LIMIT 6";
$rs3 = $conn->Execute($sql3);
while (!$rs3->EOF) {
$news_id =$rs3->fields["news_id"];
$news_title_th =$rs3->fields["news_title_th"];
$news_title_en =$rs3->fields["news_title_en"];
$news_text_th =$rs3->fields["news_text_th"];
$news_text_en =$rs3->fields["news_text_en"];
$news_date =$rs3->fields["news_date"];
$news_pic =$rs3->fields["news_pic"];
$news_status =$rs3->fields["news_status"];
$news_add =$rs3->fields["news_add"];
$news_update =$rs3->fields["news_update"];
if($news_pic!=""){
$news_pic_p = $path3.$news_pic;
}
?>
$i3++;
if(($i3%3)==0){
echo "";
}
$rs3->MoveNext();
}
?>
