Error in select statement

[speedy]

Hi forum members

I have the following SELECT statement which aims to select data from the database for a month ago today however im getting an error message as shown below.


SELECT STATEMENT

$dbQuery="SELECT * FROM data WHERE ReportedDate BETWEEN date("Y-m-d", strtotime("-12months")) AND date("Y-m-d", strtotime("-11 months"))";

ERROR MESSAGE

Parse error: parse error, unexpected T_STRING

Any help is much appreciated in correcting the above select statement -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[ashley]

unexpected T_STRING is a php error. you are not escaping your quotes

PHP Code:
$a = "as" af";

is invalid, if you want to have quotes in there, you have to escape them

PHP Code:
$a = "as\" af";

or end the quotes

PHP Code:
$a = "as ".time()." af";

Hope I was of little help -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --