include("/home/shanghai/dbcon.inc");
$rtn=pg_exec("SELECT * FROM shcontent WHERE ctg='restaurant' AND ctgb~'west' AND description~'歴史を感じる' ORDER BY ctgb LIMIT 50");
$n=pg_num_rows($rtn);
for($i=0;$i<$n;$i++){
$row=pg_fetch_array($rtn,$i);
?>
| echo $row['title']; ?> |
住所: echo $row['add']; ?> |
if(file_exists("/home/shanghai/nicchu.com/shanghai/map/images/".$row['id']."_s.jpg")){ ?> } ?> |
| echo mb_strimwidth($row['description'],0,240,"…"); ?> |
}
?>
|
|