I'm setting up a user online system using MySQL where I have 4 fields, all of which is working fine.
I need the information from all the fields but want only distinct values based on the uname column. If I use the: SELECT DISTINCT uname FROM useronline of course I come back with the values I desire, but only the user names. As I am also tracking the page they are on I need other columns in the table as well. So the question is, using an SQL statement, how do I return only distinct useronline.uname values from the database as well as the useronline.file column? Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php