connect_error) { die("Connection failed: " . $conn->connect_error); } // Get items $sql = "SELECT name, gig_date, location, location_url, image_url, link FROM gigs WHERE gig_date >= CURDATE() ORDER BY gig_date ASC"; $result = $conn->query($sql); if ($result->num_rows > 0) { // Output data for each row while($row = $result->fetch_assoc()) { echo "
"; } } else { echo "No upcoming gigs."; } $conn->close(); ?>