есть 2 таблици 1. fishingplaces id id_region places link 2.region id_region region Как сделать чтобы вывод был такой https://prnt.sc/SP7hIiAYmMZQ в моем случае https://prnt.sc/2Q_amSFHCHUM PHP: <div class="FishPlace"> <?php $query = $mysqli->query('SELECT * FROM region'); $query1 = $mysqli->query('SELECT * FROM `fishingplaces` left JOIN region ON fishingplaces.id_region = region.id_region'); while ($row = mysqli_fetch_assoc($query)) { echo "<div class='box_FishPlace'> <div class='text_box_FishPlace'> ".$row['region']." </div>"; while ($row1= mysqli_fetch_assoc($query1)) { echo " <div class='place-fish-box'> <div class='Place-Fish'><a href='#'>". $row1['places']."</a></div> </div>"; } echo "</div>"; } ?> </div> может где ошибка в запросе sql или не правильно вывод
PHP: <div class="FishPlace"> <?php $query = $mysqli->query("SELECT * FROM region where `id_region`= '1'"); $query1 = $mysqli->query("SELECT * FROM fishingplaces where `id_region`= '1'"); while ($row = mysqli_fetch_assoc($query)) { echo "<div class='box_FishPlace'> <div class='text_box_FishPlace'> ".$row['region']." </div>"; while ($row1= mysqli_fetch_assoc($query1)) { echo " <div class='place-fish-box'> <div class='Place-Fish'><a href='#'>". $row1['places']."</a></div> </div>"; } echo "</div>"; } ?> <?php $query = $mysqli->query("SELECT * FROM region where `id_region`= '2'"); $query1 = $mysqli->query("SELECT * FROM fishingplaces where `id_region`= '2'"); while ($row = mysqli_fetch_assoc($query)) { echo "<div class='box_FishPlace'> <div class='text_box_FishPlace'> ".$row['region']." </div>"; while ($row1= mysqli_fetch_assoc($query1)) { echo " <div class='place-fish-box'> <div class='Place-Fish'><a href='#'>". $row1['places']."</a></div> </div>"; } echo "</div>"; } ?> <?php $query = $mysqli->query("SELECT * FROM region where `id_region`= '3'"); $query1 = $mysqli->query("SELECT * FROM fishingplaces where `id_region`= '3'"); while ($row = mysqli_fetch_assoc($query)) { echo "<div class='box_FishPlace'> <div class='text_box_FishPlace'> ".$row['region']." </div>"; while ($row1= mysqli_fetch_assoc($query1)) { echo " <div class='place-fish-box'> <div class='Place-Fish'><a href='#'>". $row1['places']."</a></div> </div>"; } echo "</div>"; } ?> </div>