<?php
$sehirler = array();
$meslekler = array();
$query="SELECT DISTINCT sehir FROM sources ORDER BY sehir";
$result=mysqli_query($conn,$query);
while($row = mysqli_fetch_array($result)){
array_push($sehirler, $row["sehir"]);
}
$query2="SELECT DISTINCT meslek FROM sources ORDER BY meslek";
$result2=mysqli_query($conn,$query2);
while($row2 = mysqli_fetch_array($result2)){
array_push($meslekler, $row2["meslek"]);
}
for($i=0;$i<count($sehirler);$i++){
?>
<h3>-<?php echo $sehirler[$i];?></h3>
<?php
for($j=0;$j<count($meslekler);$j++){
$query3="SELECT * FROM sources WHERE sehir='".$sehirler[$i]."' and meslek='".$meslekler[$j]."'";
$result3=mysqli_query($conn,$query3);
$rows = mysqli_num_rows($result3);
?>
<?php if($rows > 0):?><h4>---<?php echo $meslekler[$j];?></h4><?php endif;?>
<?php
while($row3 = mysqli_fetch_array($result3)){
if(isset($row3["ad"]))
?>
-----<?php echo $row3["ad"];?>
<br/><br/>
<?php
}
}
?>
<?php
}
?>