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,40) as title1,substring(news_title,41,20) as title2 from news_table where news_date<='now' and news_lang=2 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,40) as title1,substring(news_title,41,20) as title2 from news_table where news_date<='now' and news_lang=2 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;}
?>
EZ BRIGHT CORPORATION:WHAT'S NEW
![](../img/back/back2_23.jpg) |
|
|
|
|
|
|
|
|
![](../img/back/back2_32.jpg) |
![](../img/back/back2_33.jpg) |
|
|
![WHAT'S NEW WHAT'S NEW](../img/whatisnew/top_title.gif) |
![The light of safety to the living with PHOTOLUMINESCENT. The light of safety to the living with PHOTOLUMINESCENT.](../img/noflash/en_img_news.jpg) |
|
The light of safety to the living with
PHOTOLUMINESCENT.
|
|
|
|
![](../img/whatisnew/sankaku.gif) |
WHAT'S NEW |
while($dbdata_type1 = pg_fetch_array ($result_type1)){
$linkstat=$dbdata_type1["news_link_stat"];
$newsid=$dbdata_type1["news_id"];
$date=$dbdata_type1["news_date"];
$title1=$dbdata_type1["title1"];
$title2=$dbdata_type1["title2"];
$date1=substr($date,2,2).".".substr($date,5,2).".".substr($date,8,2);
?>
|
}?>
}?> |
}
?>
|
|
|
|
![](../img/whatisnew/sankaku.gif) |
TOPICS |
while($dbdata_type2 = pg_fetch_array ($result_type2)){
$linkstat=$dbdata_type2["news_link_stat"];
$newsid=$dbdata_type2["news_id"];
$date=$dbdata_type2["news_date"];
$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.
|
|
|
|