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 '' at line 1:SELECT *,(DATE_ADD(sku_release_date,INTERVAL 120 DAY)>now()) as new_flag , (DATE_ADD(sku_revise_date,INTERVAL 120 DAY)>now()) as revised_flag FROM sku where sku_id=