Joining search queries

Sorry newbie question...

I have made two different search queries on the same table.

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

Many thanks

Alec

Re: Joining search queries

"Alec" wrote in message
news:1190064167.203859.224910@19g2000hsx.googlegroups.com...
> Sorry newbie question...
>
> I have made two different search queries on the same table.
>
> How can I join these together in one list, so the results from the
> first query come listed before the second, ie keeping the same order.

no telling since you post no code. in keeping...

select *
from
(
select 'a' source
'2' field
from foo
union
select 'b' source
'1' field
from foo
) derived
order by source

Re: Joining search queries

On 17.09.2007 23:22 Alec wrote:
> Sorry newbie question...
>
> I have made two different search queries on the same table.
>
> How can I join these 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

Re: Joining search queries

Alec wrote:
> Sorry newbie question...
>
> I have made two different search queries on the same table.
>
> How can I join these together in one list, so the results from the
> first query come listed before the second, ie keeping the same order.
>
> Many thanks
>
> Alec
>

Alec,

You should be asking SQL questions in a SQL group, not a PHP group.
You'll get much better answers.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Re: Joining search queries

"Jerry Stuckle" wrote in message
news:3budneICm_NOLHLbnZ2dnUVZ_tWtnZ2d@comcast.com...
> Alec wrote:
>> Sorry newbie question...
>>
>> I have made two different search queries on the same table.
>>
>> How can I join these together in one list, so the results from the
>> first query come listed before the second, ie keeping the same order.
>>
>> Many thanks
>>
>> Alec
>>
>
> Alec,
>
> You should be asking SQL questions in a SQL group, not a PHP group. You'll
> get much better answers.

that's debatable. ;^)

Re: Joining search queries

Steve wrote:
> "Jerry Stuckle" wrote in message
> news:3budneICm_NOLHLbnZ2dnUVZ_tWtnZ2d@comcast.com...
>> Alec wrote:
>>> Sorry newbie question...
>>>
>>> I have made two different search queries on the same table.
>>>
>>> How can I join these together in one list, so the results from the
>>> first query come listed before the second, ie keeping the same order.
>>>
>>> Many thanks
>>>
>>> Alec
>>>
>> Alec,
>>
>> You should be asking SQL questions in a SQL group, not a PHP group. You'll
>> get much better answers.
>
> that's debatable. ;^)
>
>

Not at all. There are a number of possibilities here, none of which I
have seen offered in this group. But I've seen a lot of them offered in
comp.databases.mysql.

People here are PHP experts. People in comp.databases.mysql are MySQL
experts - and have vastly more knowledge about MySQL than most PHP
programmers.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Re: Joining search queries

"Jerry Stuckle" wrote in message
news:q66dndxLtZMJn23bnZ2dnUVZ_gSdnZ2d@comcast.com...
> Steve wrote:
>> "Jerry Stuckle" wrote in message
>> news:3budneICm_NOLHLbnZ2dnUVZ_tWtnZ2d@comcast.com...
>>> Alec wrote:
>>>> Sorry newbie question...
>>>>
>>>> I have made two different search queries on the same table.
>>>>
>>>> How can I join these together in one list, so the results from the
>>>> first query come listed before the second, ie keeping the same order.
>>>>
>>>> Many thanks
>>>>
>>>> Alec
>>>>
>>> Alec,
>>>
>>> You should be asking SQL questions in a SQL group, not a PHP group.
>>> You'll get much better answers.
>>
>> that's debatable. ;^)
>
> Not at all. There are a number of possibilities here, none of which I
> have seen offered in this group. But I've seen a lot of them offered in
> comp.databases.mysql.
>
> People here are PHP experts. People in comp.databases.mysql are MySQL
> experts - and have vastly more knowledge about MySQL than most PHP
> programmers.

well, i am a participant in both as most others here are. if he gives us an
idea of what he's wanting to do, i guarantee he'll get an expert response
from me. ;^)

Re: Joining search queries

On 18 Sep, 10:21, gosha bine 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

Re: Joining search queries

Alec wrote:
> On 18 Sep, 10:21, gosha bine 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
>
>

I don't know where you asked, but it certainly wasn't in
comp.databases.mysql, which is the appropriate newsgroup.

This one isn't.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Re: Joining search queries

Alec wrote:
[...]
> $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.

In SQL, you do that again by only using ONE statement.

SELECT company, address1, address2
FROM table1
WHERE category in ('active', 'inactive')
ORDER BY category ASC;