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: [EMAIL PROTECTED]
phone: 314.692.3540
-----------------------------------------------
This email sent using CDM Sports Webmail v3.1
[ http://webmail.cdmsports.com ]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
