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); } ?> 【風俗広告ドットコム】 風俗の集客宣伝・デリヘル求人の広告
【風俗広告ドットコム】風俗の集客宣伝・デリヘル求人の広告
■新着・更新情報
    prepare("SELECT * FROM `info` WHERE (`info_id` = '{$row['info_id']}')"); $stmt -> execute(); $info = $stmt->fetch(); $stmt -> closeCursor(); $date = new DateTime($row['modified']); $dt1 = $date->format('Y年m月d日'); ?>
  • " : "\"{$info['name']}\""; ?>