I have 2 tables, 'users' and 'files' (defined below)
Can I construct a single SELECT statement so that it will return ONLY
users that have files and ONLY the last file that the user has? So it
would return 1 row per user containing their most recent file.
Stamp int (unix_timestamp)
The way I'm doing it now, I use SELECT DISTINCT to get all the users
with files, then a separate query for each user returned to retrieve
their latest file. This method requires many, many individual queries
to the database?
Any help is appreciated.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php