query("SELECT * FROM site_courses"); if($category->num_rows){ while($row = $category->fetch_assoc()){ $chk = $con->query("SELECT * FROM courses WHERE categary = '".$row['id']."' "); if($chk->num_rows){ $courses = []; while($r = $chk->fetch_assoc()){ $courses[] = $r; } $cats[$row['id']] = [ 'title' => $row['title'], 'courses' => $courses ]; } } } echo front_header_navigarion('Our Courses'); ?>
Select Category
$r){ echo '
'.$r['title'].'
'; } ?>
$r){ ?>
Category
Courses
Duration
'.$r['title'].'
'.$course['course_name'].'
'.$course['duration'].'
'; } ?>