Select results from past 7 days

[guestabc]

I currently have the query shown below

$sSQL=	"SELECT * FROM Results WHERE sUsername='$sTipsterID' AND sWonLost='Won' OR sUsername='$sTipsterID' AND sWonLost='Placed' sDate1 between date_sub(curdate(),INTERVAL 7 DAY) and curdate(ORDER BY sDate1 DESC ;";

 

however i'm getting the following error message

Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Unknown<br/><b>Description:</b> Unknown' in E:\path\to\tipsterdetails.php:142 Stack trace: #0 E:\path\to\tipsterdetails.php(142): com->Execute('SELECT * FROM q...') #1 {main} thrown in E:\path\to\tipsterdetails.php on line 142

 

 

[Mark Baker]

Try looking at your SQL query

SELECT * FROM Results 
WHERE (sUsername='$sTipsterID' 
    AND sWonLost='Won')
     OR (sUsername='$sTipsterID' 
   AND sWonLost='Placed')
   AND sDate1 between date_sub(curdate(),INTERVAL 7 DAY) and curdate()
ORDER BY sDate1 DESC

[guestabc]

i have implemented the changes and now get the following error:

 

Parse error: syntax error, unexpected T_STRING in E:\path\to\tipsterdetails.php on line 141