On Tue, 02 Oct 2007 18:02:58 -0700, ½aßrain <mccbrad@gmail.com> wrote:

>Hi Guys,
>
>I have a table of events with a start and finish datetime.
>
>I am trying to write a php function that will return the next earliest
>start time that an event will fit. Will this be something that I can
>do just in mysql?
>
>or something much more complex?
>
>anyone have any tips?

SELECT * FROM mytable
WHERE start > NOW()
ORDER BY start
LIMIT 1