|
|
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
Navigation:
[Reply to this message]
|