SELECT few rows..

[mykone]

I have two tables. Group, and Content

I want to show all Groups, and only 3 rows from Content even if there are more.

similar to..

Cars - Benz
Cars - Honday
Cars - Toyota
Sports - Soccer
Sports - Football
Sports - Basketball

Currently i have this:
SELECT g.id, g.name category, c.c_title as content, c.c_group
FROM groups g
INNER JOIN content c ON c.c_group = g.id
WHERE c.approved = 1
ORDER BY g.name

What should be done to the above statement to
get only 3 rows per group from the content table?

[Anon]

Try the word LIMIT as in:

SELECT field FROM table LIMIT 0,3

fLIPIS

[Anon]

Can't be done with one query in Mysql. You can do it your PHP script by keeping track of when the groupid changes and the count records.

[mykone]

That's what I did Lars Berg. I had a feeling it wasn't possible. fLIPIS didn't understand the question. LIMIT only limits the final result set not each grouped set.