Event Scheduler

[Alex]

In relation to Schedules, would it be possible to have an automated schedule randomizer,which you could list certain routes to be randomized and then say every three hours the times change unless bid on?

so although the route stays the same it rotates over 24hrs to enable more people from accross the globe to select a more appropriate timed schedule?

thoughts or comments?

[Nabeel]

If you enter the start times properly, you can easily pick out the schedules which are around that time period. But yes, what you want to do is easily possible as well.

[Alex]

My response was going to be, in the schedule search, i would like to add a search for all flights departing in less than one hour.

Is there a quick code snippet available?

i managed to get to here but need the scripty bit to search

<div id="time">

	<p>Select Nearest Departure Time :</p>

	<select id="type" name="type">


		<option value="less">Less Than</option>

	</select>
	<label>
	<select name="time" id="time2">
	  <option>1 hour</option>
	  <option>5 hours</option>
	  <option>10 hours</option>
	  <option>24 hours</option>
    </select>
  </label>
	<input type="submit" name="submit" value="Find Flights" />

[Nabeel]

You'd have to find the query, I don't remember it off the top of my head but it' would be something like:

// This query might need some work, something like this though
$where = array("DATE_SUB(NOW(), 'INTERVAL 60 MINUTE') <= s.deptime");
$schedules_list = SchedulesData::findSchedules($where);

And that will return the list. The documentation has the details on how to then loop through $schedules_list