prepare("Select link_category, category_name from link_categories where link_category='$group'") or die("Error preparing the database1"); $links->execute(); $links->bind_result($link_category, $category_name); $links->fetch() ?>

prepare("Select website, image, alt_text, link_category from links where link_category='$group' Order by alt_text") or die("Error preparing the database2"); $stmt->execute(); $stmt->bind_result($website, $image, $alt_text, $link_category); while($stmt->fetch()): ?> prepare("Select advert_code, links_page from adverts where links_page='$group'") or die("Error preparing the database 3"); $stmt4->execute(); $stmt4->bind_result($advert_code, $links_page); while($sql_advert=$stmt4->fetch()): ?>