public function displayFeatured() { $markup = "\n<ul id=\"featured-gallery\">"; // Select the featured gallery titles $sql = "SELECT id, page\n FROM `" . DB_NAME . "`.`" . DB_PREFIX . "entryMgr`\n WHERE data7='featured'"; $stmt = $this->mysqli->prepare($sql); $stmt->execute(); $stmt->bind_result($id, $page); // Create a new ImageGallery object $gal = new ImageGallery(); // Loop through the featured cars while ($stmt->fetch()) { $gal->dir = "img/gallery/{$page}{$id}/preview/"; $gal->getImages(); $img = $gal->getFirstImage(); $markup .= "\n\t<li><a href=\"/{$page}/{$id}\"><img src=\"/{$img}\" alt=\"Featured Customization\" /></a></li>"; } return $markup . "\n</ul>\n"; }