锘??php
include_once 'public.php';
include_once 'top.php';
$sql = "SELECT * FROM tdjj where id=1";
$result = mysql_query($sql);
$rs = mysql_fetch_object($result);
$smarty->assign('tdjj',$rs->tdjj);
//浠ユ璇存硶
$sql1 = "SELECT * FROM algl ORDER BY rq desc limit 10";
$result1 = mysql_query($sql1);
while(@$rs1 = mysql_fetch_object($result1))
{
$alarray[] = array("albt"=>$rs1->bt,"alrq"=>$rs1->rq,"alglid"=>$rs1->id);
}
$smarty->assign("alArray",$alarray);
//flash
$sqlflash = "SELECT * FROM flash limit 5";
$resultflash = mysql_query($sqlflash);
while(@$rsflash = mysql_fetch_object($resultflash))
{
$flasharray[] = array(
"flashtp"=>$rsflash->tp,
"flashlink"=>$rsflash->link,
"flashid"=>$rsflash->id,
"flashbt"=>$rsflash->bt,
);
}
$smarty->assign("flashArray",$flasharray);
//娉曞緥鏉傝皥
$sql2 = "SELECT * FROM ztgl ORDER BY rq desc limit 10";
$result2 = mysql_query($sql2);
while($rs2 = mysql_fetch_object($result2))
{
$ztarray[] = array("ztglid"=>$rs2->id,"ztbt"=>$rs2->bt,"ztrq"=>$rs2->rq);
}
$smarty->assign("ztArray",$ztarray);
//娉曞緥鍜ㄨ
$sql3 = "SELECT * FROM flzx ORDER BY rq desc limit 10";
$result3 = mysql_query($sql3);
while($rs3 = mysql_fetch_object($result3))
{
$zxarray[] = array("zxglid"=>$rs3->id,"zxbt"=>$rs3->bt,"zxrq"=>$rs3->rq);
}
$smarty->assign("zxArray",$zxarray);
//缃戠珯鍏憡
$sql4 = "SELECT * FROM wzgg ORDER BY rq desc limit 10";
$result4 = mysql_query($sql4);
while($rs4 = mysql_fetch_object($result4))
{
$ggarray[] = array("ggid"=>$rs4->id,"ggbt"=>$rs4->bt,"ggrq"=>$rs4->rq);
}
$smarty->assign("ggArray",$ggarray);
//falvfagui
$sqlf = "SELECT * FROM flfg ORDER BY rq desc limit 10";
$resultf = mysql_query($sqlf);
while($rsf = mysql_fetch_object($resultf))
{
$flfgarray[] = array("flfgid"=>$rsf->id,"flbt"=>$rsf->bt,"flrq"=>$rsf->rq);
}
$smarty->assign("flfgArray",$flfgarray);
include_once 'foot.php';
$smarty->display('index.tpl');
?>