|
|
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/videotwo/public_html/coupon24/include/paging.php on line 15
SELECT DISTINCT(D.ID), D.image, D.fullname, D.sex, D.age, D.country_id, D.state_id,
D.province_id, D.lookingfor, D.audio_filename FROM dating D
LEFT JOIN members M ON D.email = M.email AND M.active = 1
WHERE (D.active = 1 )
AND('' = '' OR D.country_id = '')
AND('' = '' OR D.state_id = '')
AND('' = '' OR D.province_id= '')
AND('' = '' OR D.catID = '')
AND('%%' = '' OR D.email LIKE '%%' OR D.zipCode LIKE '%%' OR D.fullname LIKE '%%'
OR D.religion LIKE '%%' OR D.education LIKE '%%' OR D.yourJob LIKE '%%' OR D.smoking LIKE '%%'
OR D.drinking LIKE '%%' OR D.bodytype LIKE '%%' OR D.marital LIKE '%%' OR D.goal LIKE '%%'
OR D.freetime LIKE '%%' OR D.yourself LIKE '%%' OR D.lookingfor LIKE '%%' OR D.goal LIKE '%%'
)
GROUP BY D.ID
ORDER BY position, D.postedDate DESC LIMIT 0, 30 | | |
