|
|
Posted by Alec on 10/08/07 13:20
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 help 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
Navigation:
[Reply to this message]
|