include "db_connect.inc"; $query = " select content_no,content,date_format(insert_date,'%Y/%m/%d') as insert_date2,date_format(update_date,'%Y/%m/%d') as update_date2 ". " from content_table ". " where content_type='01' ". " and view_kbn='1' ". " and language='1' ". " order by insert_date desc "; $result = mysql_query($query); $rc = mysql_fetch_object($result); ?> $page_title="PARC Audio/ウッドコーンや自作スピーカーのドリームクリエーションです"?> $pan_list=""?>
print($rc->content); ?> |
$query2 = " select news_no,news,view_kbn,date_str,date_format(start_date,'%Y.%m.%d') as start_date3,date_format(update_date,'%Y/%m/%d') as update_date2 ".
" from news_table ".
" where language='1' ".
" and view_kbn='1' ".
" and date_format(start_date,'%Y.%m.%d')<=date_format(CURRENT_TIMESTAMP(),'%Y.%m.%d') ".
" and (end_date is NULL or date_format(end_date,'%Y.%m.%d')>=date_format(CURRENT_TIMESTAMP(),'%Y.%m.%d')) ".
" order by start_date desc,news_no desc ";
$result2 = mysql_query($query2);
if(mysql_num_rows($result2)>=0){
$n_count=0;
while($rc2=mysql_fetch_object($result2)){
?>
}?> date_str!="")print($rc2->date_str); else print($rc2->start_date3);?> news)?> $n_count++; } }else print("新着情報はございません。"); ?> |
|