New search query in Flight Search Page

[RichardRodgers]

Hi guys,

I am looking to add a search drop down to the Find a flight serach page that will allow me to use the data in the NOTES box of a flight schedule.

The following code is for the search parameters that are concerned with searching by DEPARTURE AIRPORT

<div id="depapttab">

<p>Select your departure airport:</p>

<select id="depicao" name="depicao">

<option value="">Select All</option>

<?php

if(!$depairports) $depairports = array();

foreach($depairports as $airport)

{

echo '<option value="'.$airport->icao.'">'.$airport->icao

.' ('.$airport->name.')</option>';

}

?>

</select>

<input type="submit" name="submit" value="Find Flights" />

</div>

What would I need to change to get this to search by the NOTES instead.

The reason I ask is that we use the NOTES box to contain a pilots name, and so wish to be able to search for all flights relating to a particular pilot.

As always, any help gratefully received.

Richard