Search the Community

Here is The Code: if ($handle = @opendir("../../images/year/$year/")) { $blacklist = array('.', '..', 'index.php', 'index.html'); while (false !== ($file = readdir($handle))) { if (!in_array($file, $blacklist)) { $stmt = $mysqli->prepare("SELECT id, image, title, caption, secureid FROM photogallery WHERE image = ? AND year = ? AND timeofday = ? LIMIT 5"); $stmt->bind_param('sis', $file, $year, $timeofday); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($id, $image, $title, $caption, $photoid); //$stmt->fetch(); while ($stmt->fetch()) { if (($id) && ($photoid)){ $idcheck = "<font color=\"green\">Found in Database</font>"; $admin = "<a href=\"../edit/photos.php?photoid=$photoid\">Edit</a>"; $details = "<b>$title</b> $caption"; } else { $idcheck = "<font color=\"red\">Not Found in Database</font>"; $admin = "<a href=\"../add/photos.php?image=$file&year=$year&timeofday=$timeofday\">Add</a>"; $details = ""; } echo "$image $details $idcheck $admin<br>"; } $stmt->close(); echo "$file $details $idcheck $admin<br>"; } } closedir($handle); } else {echo "This image directory was not found.";} What It is Doing: Right now it is only showing the ones found in the database. What I Want It To Do: I want it to show all the results found in the database and the ones that are not found in the database. So I can see everything. If you need any more information. Please ask.