Posted by Tim Van Wassenhove on 04/11/06 03:11
On 2006-04-10, Ridge Burner <nospam@nospam.com> wrote:
> I'm looking for a SQL statement like so:
>
> $sql = "SELECT first 3 items for each UNIQUE user ORDER BY date_added ASC";
I can only think of a solution where you perform a subquery to get the
desired results. Which SQL-DBMS are you using? And which version? If i'm
not mistaken MySQL only supports subqueries since version 4.1.
--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>
Navigation:
[Reply to this message]
|