UNION Order

[darko886]

Hi, I have the following:

$result = mysql_query( "SELECT DISTINCT Departure FROM `$division` WHERE `Aircraft`='$aircraft' UNION SELECT DISTINCT Arrival FROM `$division` WHERE `Aircraft`='$aircraft'" ) 
or die("SELECT Error: ".mysql_error()); 
$num_rows = mysql_num_rows($result); 

And then I display that in a table... The only problem is is that I would like it to order the whole thing after it has combined them into alphabetical order. For example, Departures and Arrivals have city names and after I combine them I need it to order them all.

Thanks!

[laserlight]

You can use an ORDER BY city after the UNION. You might have to retrieve the city names too, but I cannot quite remember offhand.

[ragedigital]

$result = mysql_query( "(SELECT DISTINCT Departure as Cityname FROM $division WHERE Aircraft='$aircraft') UNION (SELECT DISTINCT Arrival as Cityname FROM $division WHERE Aircraft='$aircraft') ORDER BY 1" )
or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);

while($getInfo = mysql_fetch_array($result))
echo $getInfo['Cityname'];