Can you post a schema with some test data?
I'd be happy to play around with it for a few minutes, but I don't have
time to setup a test case right now.
Thanks,
Jeromie
>>SELECT customer, transaction date, transaction code FROM SAMPLE_TABLE
>>WHERE MAX(transaction_date);
>>
>>
>
>Error Code : 1111
>Invalid use of group function
>
>...but I don't have the correct answer yet...
>
>
>
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/