"Vernon" <[EMAIL PROTECTED]> escribió en el mensaje news:[EMAIL PROTECTED] > 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
You can try using an INNER JOIN syntax. Like this: SELECT DISTINCT(useronline.uname) FROM useronline INNER JOIN file ON file.useronline = useronline.name WHERE useronline.uname LIKE' %your_Criteria_1%' AND file.useronline LIKE '%you_criteria_2%' I dunno if this is what you're looking for. Hope it helps fLIPIS -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
