prepare("SELECT id,name,description FROM tblSubcategory WHERE status=0 AND catid=?");
$stmt->bind_param('s',$innerid);
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($subid,$name,$description);
if($stmt->num_rows > 0){
while($stmt->fetch()){
$stmt1 = $db->prepare("SELECT file FROM tblGallery WHERE status=0 AND subcatid=? ORDER BY RAND () LIMIT 1");
$stmt1->bind_param('s',$subid);
$stmt1->execute();
$stmt1->store_result();
$stmt1->bind_result($file);
$stmt1->fetch();
$stmt1->close();
echo '
';
}
}
$stmt->close();
?>
'.$name.'