multi-d array frustration

having alot of difficulties wrapping my head around this and looking for ideas... SQL TABLE: 1...n fields auto, name, description, version, etc... auto = unique id name = possibly non-unique string, but with unique version description = possibly non-unique string, based on name version = unique to name ie. 1 typeX X brand 1 2 typeX x-brand 2 3 typeY y-brand 1 4 typeZ z-brand 1 5 typeZ Z brand 2 sql = select * from table where [ conditions ] order by auto problem: display unique name, and associated rows based on highest version ie. (see above) typeX (version 2): x-brand typeY (version 1): y-brand typeZ (version 2): Z brand through a mixture of the original sql query, multisort_array and array_unique, I have been able to get the unique names (which I could do with one sql query), however, I have not been able to get: select * from table where [conditions] and greatest version for unique name any help appreciated ======================================= Michael Geier CDM Sports, Inc. Systems Administration email: operations@cdmsports.com phone: 314.692.3540 ----------------------------------------------- This email sent using CDM Sports Webmail v3.1 [ http://webmail.cdmsports.com ]