SQL / PHP仅显示即将发生的事件

Question

Hope everyone is awesome. What is the best way to display only future events in an event list which is generated by PHP and SQL.

function select_events($sql) {
include 'connect.php';

$result = $conn->query($sql);
if ($result->num_rows > 0) {
    echo "<table id='event-list'>

            <tr>

                <th id='event'>Event</th>

                <th id='date-of-event'>Date</th>

                <th id='time'>Time</th>

                <th id='place'>Place</th>

                <th id='admission'>Admission</th>

            </tr>";
}
while ($row = $result->fetch_assoc()) {
    $date = new DateTime($row['date']);
    $formatted_date = $date->format('d/m/Y');
    $time = new DateTime($row['time']);
    $formatted_time = $time->format('HH:MM');
    echo "<tr>

            <td id='event'>".$row['event']."</td>

            <td id='date-of-event'>".$formatted_date."</td>

            <td id='time'>".$row['time']."</td>

            <td id='place'>".$row['place']."</td>

            <td id='admission'>".$row['admissions']."</td>

       </tr>
";
}
echo "</table>
";
}


<?php select_events("SElECT * FROM events ORDER BY date, time"); ?>

Thanks everyone in advance. :)

Answer 1

try this,

<?php select_events("SElECT * FROM events WHERE `date` >= CURDATE() ORDER BY `date`, `time`"); ?>

use backticks for mysql reserved keywords