Re: Appending query result sets?

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

 



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


-- 
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