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<br />400：SELECT AVG(close) FROM fx_4price WHERE pea='USDJPY' AND date<=20051006 AND date>=