I think you are not using DISTINCT correctly ... try SELECT DISTINCT
whatever instead of the ()s. Also, the use of * and DISTINCT together
really makes no sense ... in the SQL, you are saying select only one record,
then select everything, which are opposites.
Don't mean to be rude, but I recommend picking up a good book on database
Trilogy International, Inc.
From: Sparky Kopetzky [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 05, 2003 12:20 PM
To: PHP DB Group
Subject: [PHP-DB] Very confused with query
I'm trying to select 1 and only one record from each user based on the last
date from a transaction file. This is what I'm using and it's not even
close. It seems DISTINCT does not work!!
SELECT DISCTINCT(transaction_user_id), MAX(transaction_date), * FROM
Could some kind soul help me figure this one out??
Robin E. Kopetzky
Black Mesa Computers/Internet Services
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php