A

#### Anonymous

##### Guest

ok i have a mysql table called Rita with two rows "aid" and pid"

now in each entry the "pid" will be different but the "aid" may be the same for example:

"pid" "aid"

1 1

2 1

3 1

4 2

5 2

6 2

7 3

8 3

9 3

now in the above example 123 is 1, 456 is 2 and 789 is 3.

but what i need to do is only select the lowest "pid" from each "aid" so what i would end up with is 1,4 and 7.

does that make sense.

im still learning php/mysql and this has been bugging me for days so any help would be greatly appreciated.

thanks