'NEWS', '1'=>'PICKUP', '2'=>'重要なお知らせ'); $query = "SELECT * FROM com_news WHERE activeflg = 1 order by sort desc limit 5"; $result = pg_query($db, $query); $number = pg_num_rows($result); $row = @pg_fetch_assoc($result); //////////////////////////////////////////////////////////////////////// print << NEWS-HARIO株式会社
HOME  >  NEWS
NEWS
お知らせ一覧
HERE; for($i=0; $i<$number; $i++){ $date = pg_result($result,$i,"date"); $title = pg_result($result,$i,"title"); $url = pg_result($result,$i,"url"); $category = pg_result($result,$i,"category"); if (isset($date) && !empty($date)) { $date = date('Y. m. d' ,strtotime($date)); } foreach($array_category as $k => $v){ if ($category === (string) $k) { $category = $v; break; } } if (isset($url) && !empty($url)) { $a_s = ""; $a_e = ""; } else { $a_s = ""; $a_e = ""; } print <<
$category
  $date           $a_s$title$a_e
HERE; } print <<
HERE; ?>