Catch the next event with Mysql

0

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

Togetthescheduleforthecurrentday,Ididthis:

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

And the next event, how can I get it?

    
asked by anonymous 13.07.2018 / 16:10

1 answer

0

I was able to resolve it as follows:

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