= $dt1; ?>
= h($row['title']); ?>
= strip_tags($row['comment']); ?>
query($sql) as $row){ array_push($news01, $row); } //新着・更新情報(風俗営業媒体) $news02 = array(); $sql = "SELECT * FROM `info` INNER JOIN `info_news` ON info.info_id = info_news.info_id WHERE (info.flg = 0) AND (info_news.flg = 0) AND (info.genre01 = 1) ORDER BY info_news.modified DESC"; foreach($dbh -> query($sql) as $row){ array_push($news02, $row); } //新着・更新情報(女性求人媒体) $news03 = array(); $sql = "SELECT * FROM `info` INNER JOIN `info_news` ON info.info_id = info_news.info_id WHERE (info.flg = 0) AND (info_news.flg = 0) AND (info.genre02 = 1) ORDER BY info_news.modified DESC"; foreach($dbh -> query($sql) as $row){ array_push($news03, $row); } //新着・更新情報(男性求人媒体) $news04 = array(); $sql = "SELECT * FROM `info` INNER JOIN `info_news` ON info.info_id = info_news.info_id WHERE (info.flg = 0) AND (info_news.flg = 0) AND (info.genre03 = 1) ORDER BY info_news.modified DESC"; foreach($dbh -> query($sql) as $row){ array_push($news04, $row); } //新着・更新情報(その他) $news05 = array(); $sql = "SELECT * FROM `info` INNER JOIN `info_news` ON info.info_id = info_news.info_id WHERE (info.flg = 0) AND (info_news.flg = 0) AND (info.genre04 = 1) ORDER BY info_news.modified DESC"; foreach($dbh -> query($sql) as $row){ array_push($news05, $row); } ?>
= $dt1; ?>
= h($row['title']); ?>
= strip_tags($row['comment']); ?>
= $dt1; ?>
= h($row['title']); ?>
= strip_tags($row['comment']); ?>