prepare("SELECT id,name,title,description FROM tblCategory WHERE id=?"); } else if(isset($_GET['url'])){ $innerid = $_GET['url']; $stmt = $db->prepare("SELECT id,name,title,description FROM tblCategory WHERE url=?"); } $stmt->bind_param('s',$innerid); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($innerid,$category,$title,$description); $stmt->fetch(); $stmt->close(); include('required-head.php');?> <? echo $title; ?> | MNG Academy ">

prepare("SELECT title,duration,eligibility,description,image FROM tblCourse WHERE status=0 AND catid=?"); $stmt->bind_param('s',$innerid); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($title,$duration,$eligibility,$description,$image); if($stmt->num_rows > 0){ while($stmt->fetch()){ echo '
'; if($image !== ''){ echo ''; } echo '

'.$title.'

Duration : '.$duration.'

Eligibility: '.$eligibility.'

CAREER PROSPECT

'.$description.'
'; } } $stmt->close(); ?>