MYSQL help needed!

I recently got the error message below on my site and am trying to figure out why

“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 product_status=1 AND (1285119555 BETWEEN product_starting_date AND product_c’ at line 1”

Can anyone provide any potential reasons why this is occurring?

The error message tells you quite clearly you have a syntax error in your query.

But if you don’t post the actual query that you are running in its entirety, I would be only guessing as to what you have done wrong.

You didn’t say in your first post that it was working correctly previously.

Regarding sql injection - have you checked if your query is vulnerable to sql injection because I can’t tell if it is or isn’t without seeing the code that creates and runs the query.

I realize it is a syntax problem, im trying to figure out why it has occured… since it was working fine the other day and I didnt make any changes…

Could it be a SQL injection/attack or what are the possible reasons this error just decides to pop up?

any particular reason why you cannot show the entire query?