$s1="西藏";
$temp1=$s1;
$temp2=$s1;
$temp3="/template/images/lie_1_s1.jpg";
$sql="select * from phome_ecms_news where checked=1 and classid=23 and title='".$s1."' order by id desc limit 0,1 ";
?>
[e:loop={$sql,1,24,0}]
$temp1=$bqr[keyboard];
$temp2=$bqr[smalltext];
$temp3=$bqr[titlepic];
?>
[/e:loop]
国内旅游:
$sql="select A.TITLE,B.filepath from phome_ecms_news A,phome_enewsuserlist B where A.checked=1 and A.classid=25 and A.title= B.listname order by A.id desc limit 0,100";
$sql1=$empire->query($sql);
while($r=$empire->fetch($sql1))
{
echo " ".$r[TITLE]." ";
}
?>
出境旅游:
$sql="select A.TITLE,B.filepath from phome_ecms_news A,phome_enewsuserlist B where A.checked=1 and A.classid=26 and A.title= B.listname order by A.id desc limit 0,100";
$sql1=$empire->query($sql);
while($r=$empire->fetch($sql1))
{
echo " ".$r[TITLE]." ";
}
?>
河南旅游:
$sql="select A.TITLE,B.filepath from phome_ecms_news A,phome_enewsuserlist B where A.checked=1 and A.classid=27 and A.title= B.listname order by A.id desc limit 0,100";
$sql1=$empire->query($sql);
while($r=$empire->fetch($sql1))
{
echo " ".$r[TITLE]." ";
}
?>