$sql="select * from tb_form where type_new='$id_type' order by date_new desc ";
$result=mysql_db_query($dbname,$sql);
$total=mysql_num_rows($result);
echo " ";
echo "$newtype[$id_type] [$total] ";
$sql="select * from tb_form where type_new='$id_type' order by title_new asc ";
$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];
$date_new=displaydate($r[date_new]);
$ext = strtolower(end(explode('.', $photo_new)));
if ($ext =="jpg" or $ext == "gif") {
$pic="image/gif.gif";
}else if($ext =="zip"){
$pic="images/zip.gif";
}else if($ext =="rar"){
$pic="images/rar.gif";
}else if($ext =="doc"){
$pic="images/word.gif";
}else if($ext =="xls"){
$pic="images/excel.gif";
}else if($ext =="pdf"){
$pic="images/pdf.gif";
}else{
$pic="images/no.gif";
}
echo " $title_new [$detail_new] ";
}
echo " ";
?>
|