Show results for the week
I'm trying to get my code to display all results entered into the table for the current week.
Right now my code looks like this:
however it keeps giving me errors no matter how I try to change the code. Right now the error is
$past = date('Y-m-d', strtotime('-1 weeks');
$result = mysql_query("SELECT * FROM patterns WHERE datetxt >= '$past' ORDER BY dsptxt");
I would like it to use Monday as the start day no matter what day of the week the query is run.
Parse error: syntax error, unexpected ';' in /homepages/22/d292640728/htdocs/crochet/phptest/new.php on line 9