|
|
getfirst("select * from inheritance where istop=1 order by id desc"))
{
$topid=$result[id];
if(empty($result[photo]))
{
echo "·".$result[title]." ";
}
else
{
?>
query("select * from inheritance order by id desc limit 0,5");
}
else
{
$result=$db->query("select * from inheritance where id <>$topid order by id desc limit 0,5");
}
while($row=$db->getarray($result)){
?>
·=$row[title]?>
|
|
|
|
|
|
getfirst("select * from active where istop=1 order by id desc"))
{
$topid=$result[id];
if(empty($result[photo]))
{
echo "·".$result[title]." ";
}
else
{
?>
query("select * from active order by id desc limit 0,5");
}
else
{
$result=$db->query("select * from active where id <>$topid order by id desc limit 0,5");
}
while($row=$db->getarray($result)){
?>
·=CutString($row[title],32)?>
|
|
|
|
|
query("select nid,title from notice order by nid desc limit 0,8");
//mysql_query("set names 'gb2312'");//这就是指定数据库字符集,一般放在连接数据库后面就系了
while($row=$db->getarray($result)){
?>
·=CutString($row[title],32)?>
|
|
|
|
|
getfirst("select * from topic order by id desc");
//mysql_query("set names 'gb2312'");//这就是指定数据库字符集,一般放在连接数据库后面就系了
$topid=$result[id];
?>
|
query("select id,title from topic where id <>$topid order by id desc limit 0,5");
//mysql_query("set names 'gb2312'");//这就是指定数据库字符集,一般放在连接数据库后面就系了
while($row=$db->getarray($result)){
echo "·".CutString($row[title],32)." ";
}
?> |
|
|
|
|
getfirst("select * from flavor where istop=1 order by id desc"))
{
$topid=$result[id];
if(empty($result[photo]))
{
echo "·".$result[title]." ";
}
else
{
?>
query("select * from flavor order by id desc limit 0,5");
}
else
{
$result=$db->query("select * from flavor where id <>$topid order by id desc limit 0,5");
}
while($row=$db->getarray($result)){
?>
·=CutString($row[title],32)?>
|
|
|
|
|