最新消息
-
= 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 *, 1 sortby FROM `news` WHERE major=1 AND `DeadTime` >= CURDATE())
UNION ALL
(SELECT *, 2 sortby FROM `news` WHERE major=0 OR (major=1 AND `DeadTime` < CURDATE()))
ORDER BY sortby, Time 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
";
// echo" -
$moon $day
NewsID\">$news->Title
";
// echo" -
$moon $day
NewsID\">$news->Title
";
// echo" - more