Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
Do you need the multiple [value] thingies to appear in the same query?
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
So you want to do something like display doctors in Los Angeles to other doctors in Los Angeles? Or, display females to other females in Chicago? These would each require two [value] thingies.
Having three would mean cutting your userbase pretty thin, I would think. You'd need a lot of users, but maybe you have a lot of users.
SELECT u.username, u.id, u.registerDate, c.user_id, c.avatar, c.cb_gender, c.cb_maritualstatus, c.cb_city, c.country_list, c.banned, c.cb_onlysex FROM #__comprofiler AS c, #__users AS u WHERE c.banned=0 AND (u.id = c.user_id) AND (([value] = 'both') OR ([value] = '') OR ([value] is NULL) OR ([value] = c.cb_gender)) ORDER BY u.registerDate DESC
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.