[RESOLVED] syntax error?

[lukeurtnowski]

when I run my sql query, I keep getting this error

You have an error in your SQL syntax near ''test medivas (1)', ' test medivas (2)', 'test medivas (3)', '', '', '' and a' at line 2
herees my ccode

$sql="select * from company, activity where c_id = a_c_id and
medivas in '$poc[0]', '$poc[1]', '$poc[2]', '$poc[3]', '$poc[4]', '$poc[5]' and
a_date between '{$_POST['startdate']}' and '{$_POST['enddate']}'
and priority in ('{$_POST['prioritya']}', '{$_POST['priorityb']}', '{$_POST['priorityc']}') 
GROUP BY c_name ORDER BY priority";

I can''t find anythiing amiss.
😕

[thorpe]

do yourself and us a favour and echo your $sql variable to the screen. this will help make it easier to see what your sql looks like to the db.

[lukeurtnowski]

k, here it is (echo $sql; )

select * from company, activity where c_id = a_c_id and medivas in 'test medivas (1)', ' test medivas (2)', 'test medivas (3)', '', '', '' and a_date between '2005-01-01' and '2005-01-05' and priority in ('A', 'B', 'C') GROUP BY c_name ORDER BY priority

Thanks

[lukeurtnowski]

thanks for the hint