Below is a query which gives me the Usernames of the Last-10 Visitors to a Member's Profile...
Code SQL:
	// FORMER QUERY
	$q8 = "SELECT COALESCE(m.username,'Non-Member') AS username
			FROM visitor_log AS v
			LEFT OUTER JOIN member AS m
			ON m.id = v.visitor_id
			WHERE v.member_viewed_id=?
			ORDER BY v.created_on DESC
			LIMIT 10";

It produces output like this...
The last 10 Visitors on this page were...
username4
username4
JohnDoe
JohnDoe
Non-Member
Non-Member
Non-Member
Non-Member
Non-Member
Non-Member

Is there a way to use DISTINCT so that I would instead get a list like this...
The last 10 Visitors on this page were...
username4
JohnDoe
Non-Member

Thanks,


Debbie