How can this be done?

[huzzi]

I have a table field contains list of airports eg:
Heathrow
London
Milan
Luton

I need to create a page to give me list like this:

Heathrow to London
Heathrow to Milan
Heathrow to Luton
London to Heathrow
London to Milan
London to Luton
Milan to Heathrow
Milan to London
etc etc.....

Please help me with this.. example with codes would be great.

Many thanks in advance.

[bbreslauer]

You would need to do a query for all the airports, then run through them, and do another query for all the airports except the current one. Then you could output them all like you have above.

Alternatively, you could get all the airports as an array, then use the following code:

$airports=array();
for($i=0;$i<count($airports);$i++) {
    for ($j=0;$j<count($airports);$j++) {
        if ($i != $j) {
            echo $airports[$i] ." to ". $airports[$j];
        }
    }
}

[bpat1434]

Expanding the above post:

<?php
// Do your query here, assuming the result is stored in $result variable
while($row = mysql_fetch_array($result))
{
  $airports[] = $row['airport']; // Put the airports into an array
}

$i=0;
$total = count($airports); // Get the total airports

foreach($airports as $airport)
{
  // Loop through the airports array, giving list of destination possibilities
  for($i=0; $i<$total; $i++)
  {
    if($airports[$i] != $airport)
    {
      $airport.' to '.$airports[$i].'<br>';
    }
  }
  $i=0;
}