SELECT Unique Row

[linusx007]

Hello,

I have a database with info like this:

ID
RACK
CAGE

The racks will be different, but the cage field will have the same cage for multiple racks like this:

ID RACK CAGE

1 12 5
2 13 5
3 14 5
4 15 5
5 16 6
6 17 6
7 18 6

What I need to do is get a listing of all the cages, but I only need one listing for each cage. When I do a select on that table I get 4 5's and 3 6's. I only need 1 of the 5's and 1 of the 6's.

I hope I explaind this good enough.

Thanks.

[drawmack]

$sql = "SELECT ID,Cage FROM Cages ORDER BY Cage GROUP BY Cage";

[linusx007]

Hello,

Thanks alot, I actually forgot about GROUP.

Thanks.
Bill

[drawmack]

please mark thread resolved.