include("/home/ez-bright/inc/option.inc");
include("/home/ez-bright/inc/function.inc");
$conn = pg_connect ("host=$dbhost port=$dbport dbname=$dbname user=$dbuser password=$dbpass");
pg_set_client_encoding("SJIS");
$sql_type1 = "select *,substring(news_title,1,20) as title1,substring(news_title,21,20) as title2 from news_table where news_date<='now' and news_lang=1 and news_type=1 order by news_date desc ,news_id desc limit 3;";
$result_type1 = pg_Exec ($conn, $sql_type1);
if(!$result_type1){echo("エラー");exit;}
$sql_type2 = "select *,substring(news_title,1,20) as title1,substring(news_title,21,20) as title2 from news_table where news_date<='now' and news_lang=1 and news_type=2 order by news_date desc,news_id desc limit 3;";
$result_type2 = pg_Exec ($conn, $sql_type2);
if(!$result_type2){echo("エラー");exit;}
?>
蓄光顔料・イージーブライト株式会社・新着情報
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
蓄光顔料で、暮らしに安心の光を。 |
|
|
|
▼新着情報
while($dbdata_type1 = pg_fetch_array ($result_type1)){
$linkstat=$dbdata_type1["news_link_stat"];
$newsid=$dbdata_type1["news_id"];
$date=$dbdata_type1["news_date"];
$title=$dbdata_type1["news_title"];
$title1=$dbdata_type1["title1"];
$title2=$dbdata_type1["title2"];
$date1=substr($date,2,2).".".substr($date,5,2).".".substr($date,8,2);
?>
|
}?>}?> |
}?>
|
|
|
|
|
▼お知らせ
while($dbdata_type2 = pg_fetch_array ($result_type2)){
$linkstat=$dbdata_type2["news_link_stat"];
$newsid=$dbdata_type2["news_id"];
$date=$dbdata_type2["news_date"];
$title=$dbdata_type2["news_title"];
$title1=$dbdata_type2["title1"];
$title2=$dbdata_type2["title2"];
$date1=substr($date,2,2).".".substr($date,5,2).".".substr($date,8,2);
?>
|
}?>}?> |
}?>
|
|
|
|
Copyright (C) 2008 EZ bright co.,ltd. All Rights Reserved.
|
|
|
|