On Fri, 05 Oct 2007 06:58:22 +0200, subtenante <zzsubtenantezz@gmail.com>
wrote:

> 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

That's for the next event indeed. I gathered the OP meant 'next empty
slot'. In which case these 'slots' should either have a table or the OP
should tell us more about them.
--
Rik Wasmus