Re: Appending query result sets?
| From: | Ashley Sheridan | Date: | Sun, 08 Feb 2009 18:45:44 +0000 |
| Subject: | Re: Appending query result sets? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-287929@lists.php.net to get a copy of this message | ||
On Sun, 2009-02-08 at 12:22 -0600, Skip Evans wrote:
> Hey,
>
> Is it possible to append a result query from one call to
> mysql_query() to the end of another if the specified fields
> are identical?
>
> Something like that would accomplish ths?
> $r1 = mysql_query('some sql');
> $r2 = mysql_query('some sql');
>
> $r3 = $r1.$r2;
>
> I suppose they could be read into an array then output that
> way, but I was hoping to more easily just append the result sets.
>
> Thanks,
> Skip
>
> --
> ====================================
> 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
>
Can you not take this to the SQL itself, like maybe using some form of
join on the query.
Ash
www.ashleysheridan.co.uk