Re: Appending query result sets?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Oh, yeah, that's fine. I knew I could od it with arrays, but also looked to see if there was any way to just do an append, and I also need to sort them as well, so maybe I better get back to figuring out a join.

Skip

Ashley Sheridan wrote:
On Sun, 2009-02-08 at 12:37 -0600, Skip Evans wrote:
Ashley Sheridan wrote:
Can you not take this to the SQL itself, like maybe using some form of
join on the query.

I've been trying that, and frankly gave up, being whipped into submission and having to admin I'm not an expert DBA, but I hesitated to post the queries lest I be flamed for posting off-topic.

--
====================================
Skip Evans
Big Sky Penguin, LLC
503 S Baldwin St, #1
Madison WI 53703
608.250.2720
http://bigskypenguin.com
------------------------------------
Those of you who believe in
telekinesis, raise my hand.
  -- Kurt Vonnegut

Well if a join is not an option, what about something like this:

$r1 = mysql_query('some sql');
$r2 = mysql_query('some sql');
$results = Array();

while($row = mysql_fetch_array($r1))
{
    $results[] = $row;
}
while($row = mysql_fetch_array($r2))
{
    $results[] = $row;
}


Ash
www.ashleysheridan.co.uk



--
====================================
Skip Evans
Big Sky Penguin, LLC
503 S Baldwin St, #1
Madison WI 53703
608.250.2720
http://bigskypenguin.com
------------------------------------
Those of you who believe in
telekinesis, raise my hand.
 -- Kurt Vonnegut

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux