Returning only one row per user

[gilchrist]

Hello folks

The current, working query which is simplified for the sake of the problem:

SELECT *
FROM qa4_blogs
WHERE state > '$state'
ORDER BY posted DESC
LIMIT $limit1

The fields include 'id' obviously, and 'mid' for the member id.

Say for example the limit is 3, this will return the most recent 3 blog entries.

However, I want to ensure that within those three rows, there is not more than one per member. I need a clever clause in there.

I know this is a very simple question for you, but please share your views with me, will be appreciated.

Bye -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[naughtyboy]

hi

Please don't use select *, there is little to gain from using it. Especially when explaining a problem you need help with. it doesn't explain all your columns.

you will need to explain when there is more than one row per user which one you would like to choose from.

for instance say you have

foo bar qux 2
foo bar soo 2

which of those two you want would tell you how to write your select statement. Yes I know I'm using data different than yours but it will serve a purpose. If you don't care which row per user you would do the query one way, if you want the latest row per user you would write the query another.

Ya, this was pretty simple for me -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --