Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ) ORDER BY `UM`.`usermaster_id` desc LIMIT 11' at line 5
SELECT `UM`.`usermaster_id`, `UM`.`enroll_date`, `UM`.`display_name`, `UM`.`father_name`, `UM`.`surname`, `UM`.`profile_id`, `UM`.`username`, `UM`.`poste_by`, `UM`.`gender`, `UM`.`marital_status`, `UM`.`birth_date`, `UM`.`mother_tongue_id`, `UM`.`religion_id`, `UM`.`cast_id`, `UM`.`sub_cast_id`, `UM`.`height`, `UM`.`contact_no1`, `UM`.`highest_degree`, `UM`.`occupation`, `UM`.`income_range`, `UM`.`membership_type`, `UM`.`package_id`, `UM`.`active`, `UM`.`country_id`, `UM`.`city_id`, `UM`.`expiry_date`, `UM`.`pack_renew_date`, `UM`.`amount`, TIMESTAMPDIFF(YEAR, `birth_date`, CURDATE()) as newage FROM (`user_master` UM) WHERE `UM`.`active` = 1 GROUP BY `UM`.`usermaster_id` HAVING ( newage BETWEEN AND ) ORDER BY `UM`.`usermaster_id` desc LIMIT 11
Filename: /home/bhavbandhsk26/public_html/modules/users/models/search_model.php
Line Number: 730