Thread: Error in select statement
View Single Post
  #1  
Old 08-19-2006, 10:31 AM
speedy speedy is offline
OSP Starters
  
Join Date: Aug 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
speedy is on a distinguished road
Default Error in select statement
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 --
Reply With Quote
  Webmaster Forums - View Single Post - Error in select statement
Thread: Error in select statement
View Single Post
  #1  
Old 08-19-2006, 10:31 AM
speedy speedy is offline
OSP Starters
  
Join Date: Aug 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
speedy is on a distinguished road
Default Error in select statement
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 --
Reply With Quote