1064 mySQL错误：AS薪水在第6行的resume.jobsalaryrange = salary.id'

Question

I get this error:

1064 You have an error in your SQL syntax; AS salary ON resume.jobsalaryrange = salary.id ' at line 6 SQL=SELECT resume.*, cat.cat_title, jobtype.title AS jobtypetitle , salary.rangestart, salary.rangeend , currency.symbol FROM_js_job_resumeAS resume JOIN_js_job_jobtypesAS jobtype ON resume.jobtype = jobtype.id LEFT JOIN_js_job_currenciesAS currency ON currency.id = resume.currencyid AND currency.id = LEFT JOIN_js_job_salaryrangeAS salary ON resume.jobsalaryrange = salary.id ,_js_job_categoriesAS cat WHERE resume.job_category = cat.id AND resume.status = 1 AND resume.searchable = 1 AND resume.nationality = 'KE' AND resume.iamavailable = 20 AND resume.jobtype = 2

From this query:

    $db->setQuery($query);
    $total = $db->loadResult();

    if ( $total <= $limitstart ) $limitstart = 0;
    $query = "SELECT resume.*, cat.cat_title, jobtype.title AS jobtypetitle
            , salary.rangestart, salary.rangeend , currency.symbol
            FROM `#__js_job_resume` AS resume
            JOIN `#__js_job_jobtypes` AS jobtype ON resume.jobtype = jobtype.id
            LEFT JOIN `#__js_job_currencies` AS currency ON currency.id = resume.currencyid     AND currency.id =  " .$currency."       
            LEFT JOIN `#__js_job_salaryrange` AS salary ON resume.jobsalaryrange = salary.id
            , `#__js_job_categories` AS cat ";
        $query .= "WHERE resume.job_category = cat.id AND resume.status = 1 AND resume.searchable = 1";
    $query .= $wherequery;

Anybody any clue? It's a tough one for me!

Answer 1

It says

AND currency.id = LEFT JOIN_js_job_salaryrange AS 

So it seems that the variable $currency is not set.

If you add just before the query:$currency = 1; just to test the query, it might work. You just have to find out what the currency id should be.