Just recently getting to grips with PHP, I have been working on an organiser that can live on the desktop as a background. The project works so far, but now I want to get a little more complicated by having the events displayed change colour for one hour before the event.

The whole thing works from mySQL and the date and time are input as separate entries by the input form. The query to display results reads these two and outputs in order, only displaying today's events in a table. Early attempts to get each one to highlight on time have failed, so I guess my coding isn't yet right!

Any ideas folks?