show profiles with pic

[ldtiw]

Hey there,

i have this SQL which uses info selected my a member to search profiles. im wanting to add a show only profiles with photo but dont know how. i kinda have an idea, but only to get records that dont have a photo.

heres my SQL:

SELECT ipals_members.m_id as member_id, ipals_members.m_country, ipals_members.m_username, ipals_members.m_name,  ipals_members.m_age, ipals_members.m_gender, ipals_main_img.i_id, ipals_main_img.m_id, ipals_main_img.i_active, ipals_country.country_name_english, ipals_profile.m_id, ipals_users_online.user
FROM ipals_members LEFT JOIN ipals_main_img ON ipals_members.m_id = ipals_main_img.m_id LEFT JOIN ipals_country ON ipals_country.country_code = ipals_members.m_country LEFT JOIN ipals_profile ON ipals_members.m_id = ipals_profile.m_id LEFT JOIN ipals_users_online ON ipals_members.m_id = ipals_users_online.user
WHERE ipals_members.m_age >= '$agefrom' AND  ipals_members.m_age <= '$ageto' AND ipals_members.m_gender LIKE '%$gender%' AND ipals_members.m_country LIKE '%$country%' AND ipals_members.m_id = ipals_profile.m_id
GROUP BY ipals_members.m_id
ORDER BY ipals_members.m_last_logged DESC

Help would be great!

Danny

[pohopo]

First you need a field that tells you if a profile has a photo. We will say that field name is ipals_members.m_photo where 'Y' means you do have photo and 'N' means you do not. So the SQL would be

SELECT ipals_members.m_id as member_id, ipals_members.m_country, ipals_members.m_username, ipals_members.m_name,  ipals_members.m_age, ipals_members.m_gender, ipals_main_img.i_id, ipals_main_img.m_id, ipals_main_img.i_active, ipals_country.country_name_english, ipals_profile.m_id, ipals_users_online.user
FROM ipals_members LEFT JOIN ipals_main_img ON ipals_members.m_id = ipals_main_img.m_id LEFT JOIN ipals_country ON ipals_country.country_code = ipals_members.m_country LEFT JOIN ipals_profile ON ipals_members.m_id = ipals_profile.m_id LEFT JOIN ipals_users_online ON ipals_members.m_id = ipals_users_online.user
WHERE ipals_members.m_photo = 'Y' AND ipals_members.m_age >= '$agefrom' AND  ipals_members.m_age <= '$ageto' AND ipals_members.m_gender LIKE '%$gender%' AND ipals_members.m_country LIKE '%$country%' AND ipals_members.m_id = ipals_profile.m_id
GROUP BY ipals_members.m_id
ORDER BY ipals_members.m_last_logged DESC