On 18 Sep, 10:21, gosha bine <stereof...@gmail.com> wrote:
> On 17.09.2007 23:22Alecwrote:
>
> > Sorry newbie question...
>
> > I have made two different search queries on the same table.
>
> > How can Ijointhese together in one list, so the results from the
> > first query come listed before the second, ie keeping the same order.
>
> $results = array();
>
> while($row = mysql_fetch_assoc($query_1))
> $results[] = $row;
>
> while($row = mysql_fetch_assoc($query_2))
> $results[] = $row;
>
> If this is not what you're looking for, please be more specific.
>
> --
> gosha bine
>
> makrell ~http://www.tagarga.com/blok/makrell
> php done right http://code.google.com/p/pihipi

Gosha

Thanks for the and sorry for the delay in a reply.

Sadly I have tried the SQL group today but with no joy.

To be more specific about the problem, 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