Catch the next event with Mysql

Question

I have a system from which take the current day schedule and the next schedule, see:

To get the current day’s schedule, I did it this way:

// DataAgenda = NOW()
mysqli_query($this-conexao,"SELECT * FROM agenda WHERE DATE(DataAgenda) = CURDATE()");

And the next event, how can I catch it?

Answer 1

I was able to solve it this way:

mysqli_query($this-conexao,"SELECT * FROM agenda WHERE DATE(DataAgenda) > CURDATE() ORDER BY DataAgenda LIMIT 1");