$query = mysqli_query($link, "SELECT * FROM schedule WHERE month = '$this_month' ORDER by datetime ASC") or die(mysqli_error()); if(mysqli_num_rows($query) > 0) { while($list = mysqli_fetch_array($query)) { // Gather variables $schedule_id = $list['id']; $class_id = $list['class_id']; $datetime = $list['datetime']; // now we get class name and info $class_list = mysqli_fetch_array(mysqli_query($link, "SELECT * FROM classes WHERE id = '$class_id'")); $class_name = $class_list['name']; $description = $class_list['description']; $filename = "/srv/www/beadhavenlasvegas.com/public_html/images/class_thumbs/" . $class_id . ".jpg"; if(file_exists($filename)) { $image = '
} } else echo "No classes have been scheduled."; ?>
$query = mysqli_query($link, "SELECT * FROM schedule WHERE month = '$next_month' ORDER by datetime ASC") or die(mysqli_error()); if(mysqli_num_rows($query) > 0) { while($list = mysqli_fetch_array($query)) { // Gather variables $schedule_id = $list['id']; $class_id = $list['class_id']; $datetime = $list['datetime']; // now we get class name and info $class_list = mysqli_fetch_array(mysqli_query($link, "SELECT * FROM classes WHERE id = '$class_id'")); $class_name = $class_list['name']; $description = $class_list['description']; $filename = "/srv/www/beadhavenlasvegas.com/public_html/images/class_thumbs/" . $class_id . ".jpg"; if(file_exists($filename)) { $image = '
} } else echo "No classes have been scheduled yet. Keep an eye on our newsletter.
"; ?>
$query = mysqli_query($link, "SELECT * FROM schedule WHERE month = '$two_months_out' ORDER by datetime ASC") or die(mysqli_error()); if(mysqli_num_rows($query) > 0) { while($list = mysqli_fetch_array($query)) { // Gather variables $schedule_id = $list['id']; $class_id = $list['class_id']; $datetime = $list['datetime']; // now we get class name and info $class_list = mysqli_fetch_array(mysqli_query($link, "SELECT * FROM classes WHERE id = '$class_id'")); $class_name = $class_list['name']; $description = $class_list['description']; $filename = "/srv/www/beadhavenlasvegas.com/public_html/images/class_thumbs/" . $class_id . ".jpg"; if(file_exists($filename)) { $image = '
} } else echo "No classes have been scheduled yet. Keep an eye on our newsletter.
"; ?>