Posted by Alec on 10/08/07 09:11

Sorry newbie question...

I have made two different search queries on the same table that both
retain the identical column information.

$resultfirst = @mysql_query ("SELECT company, address1, address2 FROM
table1 WHERE category=active ")

$resultsecond = @mysql_query ("SELECT company, address1, address2 FROM
table1 WHERE category=inactive ")

How can I now join these together in one list, with the results from
the first query being listed before the second, ie keeping the same
order.

Many thanks

Alec Thorne

[Back to original message]