0) { while($row = mysqli_fetch_assoc($result)) { $country = $row['Country']; echo " $country "; $secondquerys = "SELECT DISTINCT location FROM tbJobs WHERE Country = '$country' ORDER BY location"; $results = mysqli_query($mysqli, $secondquerys); if(mysqli_num_rows($results) > 0) { while($rows = mysqli_fetch_assoc($results)) { $location = $rows['location']; echo ""; $secondqueryss = "SELECT DISTINCT * FROM tbJobs WHERE location = '$location' ORDER BY position"; $resultss = mysqli_query($mysqli, $secondqueryss); if(mysqli_num_rows($resultss) > 0) { while($rowss = mysqli_fetch_assoc($resultss)) { $position = $rowss['position']; $jobID = $rowss['jobID']; $countrys = $rowss['Country']; $location = $rowss['location']; $reside = $rowss['reside']; $duration = $rowss['duration']; $tofbusiness = $rowss['tofbusiness']; $remuneration = $rowss['remuneration']; $importantdetails = $rowss['importantdetails']; $duties = $rowss['duties']; $responsibilities = $rowss['responsibilities']; $skills = $rowss['skills']; $qualifications = $rowss['qualifications']; $contact = $rowss['contact']; $jobtimestamp = $rowss['jobtimestamp']; $jobemail = $rowss['jobemail']; echo " "; } } else { echo "You have not entered any jobs yet."; } } } else { echo "You have not entered any jobs yet."; } } } else { echo "You have not entered any jobs yet."; } echo "

"; ?> Work with us