Amita Singh
asked on
Get error when search query run in loop
when i have serach i have get sql error.
SELECT * FROM employee_info WHERE 1 AND ( ( key_skills LIKE '%PHP%' OR job_title LIKE '%PHP%' OR current_designation LIKE '%PHP%' OR company_name LIKE '%PHP%' OR objective LIKE '%PHP%' OR resum_headline LIKE '%PHP%' OR job_responsibility LIKE '%PHP%' OR institute LIKE '%PHP%' OR institute LIKE '%PHP%') OR ( key_skills LIKE '%Java%' OR job_title LIKE '%Java%' OR current_designation LIKE '%Java%' OR company_name LIKE '%Java%' OR objective LIKE '%Java%' OR resum_headline LIKE '%Java%' OR job_responsibility LIKE '%Java%' OR institute LIKE '%Java%' OR institute LIKE '%Java%') OR ( key_skills LIKE '%HTML%' OR job_title LIKE '%HTML%' OR current_designation LIKE '%HTML%' OR company_name LIKE '%HTML%' OR objective LIKE '%HTML%' OR resum_headline LIKE '%HTML%' OR job_responsibility LIKE '%HTML%' OR institute LIKE '%HTML%' OR institute LIKE '%HTML%') ) AND total_experience < 2 GROUP BY uid DESC UNION (SELECT * FROM prev_companies WHERE pre_company_name LIKE '%PHP%' OR pre_industry LIKE '%PHP%' OR pre_functional_area LIKE '%PHP%' OR pre_responsibility LIKE '%PHP%') OR (SELECT * FROM prev_companies WHERE pre_company_name LIKE '%Java%' OR pre_industry LIKE '%Java%' OR pre_functional_area LIKE '%Java%' OR pre_responsibility LIKE '%Java%') OR (SELECT * FROM prev_companies WHERE pre_company_name LIKE '%HTML%' OR pre_industry LIKE '%HTML%' OR pre_functional_area LIKE '%HTML%' OR pre_responsibility LIKE '%HTML%')You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OR (SELECT * FROM prev_companies WHERE pre_company_name LIKE '%Java%' OR pre_ind' at line 1
SELECT * FROM employee_info WHERE 1 AND ( ( key_skills LIKE '%PHP%' OR job_title LIKE '%PHP%' OR current_designation LIKE '%PHP%' OR company_name LIKE '%PHP%' OR objective LIKE '%PHP%' OR resum_headline LIKE '%PHP%' OR job_responsibility LIKE '%PHP%' OR institute LIKE '%PHP%' OR institute LIKE '%PHP%') OR ( key_skills LIKE '%Java%' OR job_title LIKE '%Java%' OR current_designation LIKE '%Java%' OR company_name LIKE '%Java%' OR objective LIKE '%Java%' OR resum_headline LIKE '%Java%' OR job_responsibility LIKE '%Java%' OR institute LIKE '%Java%' OR institute LIKE '%Java%') OR ( key_skills LIKE '%HTML%' OR job_title LIKE '%HTML%' OR current_designation LIKE '%HTML%' OR company_name LIKE '%HTML%' OR objective LIKE '%HTML%' OR resum_headline LIKE '%HTML%' OR job_responsibility LIKE '%HTML%' OR institute LIKE '%HTML%' OR institute LIKE '%HTML%') ) AND total_experience < 2 GROUP BY uid DESC UNION (SELECT * FROM prev_companies WHERE pre_company_name LIKE '%PHP%' OR pre_industry LIKE '%PHP%' OR pre_functional_area LIKE '%PHP%' OR pre_responsibility LIKE '%PHP%') OR (SELECT * FROM prev_companies WHERE pre_company_name LIKE '%Java%' OR pre_industry LIKE '%Java%' OR pre_functional_area LIKE '%Java%' OR pre_responsibility LIKE '%Java%') OR (SELECT * FROM prev_companies WHERE pre_company_name LIKE '%HTML%' OR pre_industry LIKE '%HTML%' OR pre_functional_area LIKE '%HTML%' OR pre_responsibility LIKE '%HTML%')You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OR (SELECT * FROM prev_companies WHERE pre_company_name LIKE '%Java%' OR pre_ind' at line 1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome !!
ASKER