include "function.php";
include "connect.php";
for ($i=1;$i<=count($newtype);$i++) {
$sql="select * from tb_inews where type_new='$i' ";
$result=mysql_db_query($dbname,$sql);
$total=mysql_num_rows($result);
echo " $newtype[$i] [$total]
";
$sql="select * from tb_inews where type_new='$i' order by show_new='N', date_new desc limit 0,5";
$result=mysql_db_query($dbname,$sql);
while($r=mysql_fetch_array($result)) {
$id_new=$r[id_new];
$title_new=$r[title_new];
$type_new=$r[type_new];
$photo_new=$r[photo_new];
$detail_new=$r[detail_new];
$show_new=$r[show_new];
$date_new=displaydate($r[date_new]);
$time_new=$r[time_new];
$place_new=$r[place_new];
$count_click=$r[count_click];
$ext = strtolower(end(explode('.', $photo_new)));
/// if ($ext =="jpg" or $ext == "gif" or $ext == "png") {
/// $pic="images/gif.gif alt='ไฟล์ jpg หรือ gif หรือ png'";
/// }else if($ext =="zip"){
/// $pic="images/zip.gif alt='ไฟล์ winzip'";
/// }else if($ext =="rar"){
/// $pic="images/rar.gif alt='ไฟล์ winrar'";
/// }else if($ext =="doc"){
/// $pic="images/word.gif alt='ไฟล์ word'";
/// }else if($ext =="xls"){
/// $pic="images/excel.gif alt='ไฟล์ exel'";
/// }else if($ext =="pdf"){
/// $pic="images/pdf.gif alt='ไฟล์ pdf'";
/// }else{
/// $pic="images/no.gif alt='Link ไปหน้า URL'";
/// }
if ($show_new=="N")
{
echo "
"; echo " $title_new [$date_new] [Views $count_click] "; echo " |
"; echo " $title_new [$date_new] [Views $count_click] "; echo " |