MySQL Query exceptions
- by Wayne
In one page, it should show records that has the following selected month from the drop down menu and it is set in the ?month=March
So the query will do this
$sql = "SELECT * FROM schedule WHERE month = '" . Clean($_GET['month']) . "' AND finished='0' ORDER BY date ASC";
But it shows records that has a value of 2 in the finished column and I don't want the query to include this.
I've tried
$sql = "SELECT * FROM schedule WHERE month = '" . Clean($_GET['month']) . "' AND finished='0' OR finished = '1' OR finished = '3' ORDER BY date ASC";
But it shows records on different months when it shouldn't be.
So basically I want the record to exclude the records that has the value of 2 in the record that will not be shown in the page.
