Carl,
So I setup a test database using your parameters. I input your query
SELECT customers.name,date,code FROM customers, (SELECT name,max(date)
AS maxdate FROM customers GROUP BY name) AS maxdates WHERE
customers.name=maxdates.name AND date=maxdate;
and the database returned a bad syntax error code. My ISP uses 4.0.22
Standard of MySql
Kevin
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/
