Find next result that matches query

[Fenhopi]

I have this query to show the current class I'm in:

$GetTimeTable = "SELECT * FROM timetable WHERE username='$username' AND Subject_date='$today_date'";

 

Then I have this to display current class:

if($TimeNow >= $Start_time && $TimeNow <= $End_time){
echo "Current Class: ";
echo $Subject;}

 

How would I find next class that day?

[sasa]

change query to

$GetTimeTable = "SELECT * FROM timetable WHERE username='$username' AND Subject_date='$today_date' and end_time" > $timeNow ORDER BY end_time;

in 1st row of returned data  is curren class (if it exist) and in another row(s) is future clasesses

for current class just check if start_time is less then current time