Check It
Youth Sign up for Supper
Prayer Request
Request Information
Church Home Page
Children's Page
Supper Sign Up
connect_error) { die("Connection failed: " . $conn->connect_error); } //echo "made it here\n"; $sql = "SELECT distinct(name), date_format(sdate,'%b') as smonth, date_format(sdate, '%D') as sday FROM `youthsupper` WHERE sdate > CURRENT_DATE order by sdate "; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo "" . $row['smonth']. " " . $row['sday']. " - " . $row['name']. "
"; } } else { echo "0 results"; } $conn->close(); ?>