include("/home/shanghai/dbcon.inc");
if (!$dbcon) { echo "DB Connect Error";
}else{
$rtn = pg_exec("SELECT * FROM news_headline as l,news_honbun as b WHERE l.id=b.id AND (l.title~'上海蟹' OR b.honbun~'上海蟹') ORDER BY l.tdate DESC LIMIT 10");
$n=pg_num_rows($rtn);
if(!$rtn || !$n){ "ERROR! table news";
}else{
for($i=0;$i<$n;$i++){
$row=pg_fetch_array($rtn,$i);
$tdate = explode(" ",$row['tdate']);
$ttime = explode(":",$tdate[1]);
$tdate = explode("-",$tdate[0]);
if(time() > mktime($ttime[0],$ttime[1],0,$tdate[1],$tdate[2],$tdate[0])){
if($row['photo']=="Y"){ $photo = "

"; }else{ $photo = ""; }
?>
echo(htmlspecialchars(strip_tags($row['title']))); ?>( echo($tdate[0]); ?>/ echo($tdate[1]); ?>/ echo($tdate[2]); ?>) echo($photo); ?>

}
}
}
}
?>