duplicate results when using muliple select field

[nade93]

Hi All

 

Fenway provided me a solution to my last problem which worked great, the only issue is, i am using a search form and one of the fields uses a multiple select field. this produces duplicated results though

 

I am wanting to limit this for 1 per id, put unsure how to prepare this properly.

 

My select statement is as follows:

 

SELECT * FROM jos_community_fields_values a JOIN jos_community_users b ON a.user_id = b.userid JOIN jos_users c ON b.userid = c.id WHERE ( value='$gender' OR value='$sexuality' OR value='$height' OR value='$build' OR value='$cities' OR value='$membertype' OR value='$agegroup' OR value='$lookingfor' OR value LIKE '%$activities%

 

the $activities refers to the multiple select field.

 

is there a way i can limit this to just result displayed per id please?

 

thanks

[fenway]

That depends... what id are we talking about?