= CURDATE() Order by NewsID desc ) as temp1
#UNION all SELECT * FROM (SELECT * FROM `news` WHERE major=0 OR (`DeadTime` < CURDATE() AND major=1) Order by NewsID desc ) as temp2 ";
$select = "(SELECT * FROM `news` WHERE major=1 AND `DeadTime` >= CURDATE())
UNION all (SELECT * FROM `news` WHERE major=0 OR (`DeadTime` < CURDATE() AND major=1)) Order by NewsID desc ";
$result = mysql_query($select, $link);
$total = mysql_num_rows($result);
mysql_data_seek($result, $total - 1);
?>
Time, 5, 2); //Á|¨Ò2002-07-25 17:07:51
$day = substr($news->Time, 8, 2);
//§ìµoªí¤Hªº°ò¥»¸ê®Æ
$select2 = "SELECT * FROM newsuser WHERE User=\"$news->User\"";
if ($result2 = mysql_query($select2, $link));
$newsuser = mysql_fetch_object($result2);
if ($news->major == 1 && $news->DeadTime >= date("Y-m-d")) {
echo "
| $moon/$day |
NewsID\"> $news->Title
|
";
} else if ($i % 2 == 1) { //³æ¼Æ©M°¸¼ÆI´ºÃC¦â¤£¦P
echo "
| $moon/$day |
NewsID\">$news->Title |
";
} else {
echo "
| $moon/$day |
NewsID\">$news->Title |
";
}
} else { //end of if ¦³§ì¨ì¸ê®Æ´N¤~Åã¥Ü
echo "
| |
|
|
|
";
}
} //end of for
} //end of fonction
?>
$LastPage) $page = $LastPage;
ShowOnePage($result, $link, $page); //ShowOnePage()¥Ñ¦¹¶}©l°õ¦æ
?>
