新聞中心
$sql = "select * from press_group where lang = 'trad' order by group_id";
$groupresult = mysql_query($sql, $conn) or die("Select media failed");
while($grouprow = mysql_fetch_object($groupresult)){
echo "
".stripslashes($grouprow->group_name)."
";
if ($grouprow->divide_date == "Yes"){
$sql = "select caption, file, DATE_FORMAT(release_date, '%Y年%m月%d日') release_date from press_upload where group_id = $grouprow->group_id order by release_date desc, display_order";
}else{
$sql = "select caption, file, release_date from press_upload where group_id = $grouprow->group_id order by display_order";
}
$pressresult = mysql_query($sql, $conn) or die("Select media failed");
$firstrecord = true;
while($pressrow = mysql_fetch_object($pressresult)){
if ($grouprow->divide_date == "Yes"){
if($pressrow->release_date != $lastdate){
if(! $firstrecord) echo "";
echo "
$pressrow->release_date
";
$lastdate = $pressrow->release_date;
$firstrecord = false;
}
}else{
if($firstrecord){
echo "";
}
?>