Erro sql

[terra 1]

olá,

 

 

Esta dando esse erro

 

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 jp.salary< and jp.validity>='2011-09-08' and jp.status ='active' and emp.emp' at line 1

 

esse é o sql

 

 

$str = "select * from employer emp, jobposting jp where emp.status='active' and emp.memvalidity>='{$today}' and jp.salary>{$min_salary} and jp.salary<{$max_salary} and jp.validity>='{$today}' and jp.status ='active' and emp.emp_id=jp.empid group by jp.id";

 

 

alguém pode me ajudar?

 

 

valeu

[Andrey Knupp Vital 136]

Mostre o valor que você está passando para essa variável

$min_salary