Merch available only @ shows!
connect_error) { die("Connection failed: " . $conn->connect_error); } // Get items $sql = "SELECT item_name, description, price, color, size, image_url FROM merch WHERE availability > 0"; $result = $conn->query($sql); if ($result->num_rows > 0) { // Output data for each row while($row = $result->fetch_assoc()) { echo "" . $row["item_name"] . "
Description: " . $row["description"] . "
Price: $" . $row["price"] . "
Color: " . $row["color"] . "
Size: " . $row["size"] . "
"; } } else { echo "No merch available."; } $conn->close(); ?>