I am having a problem with my php code select, I want to select a row from a table where four conditions is meet.
$course = $_GET['Course'];
$year_enrolled = $_GET['Year_Enrolled'];
$month = $_GET['Month'];
$year = $_GET['Year'];
$sql=" SELECT * FROM dtr WHERE Course like '%$course%' OR Year_enrolled like '%$year_enrolled%' AND Month like '%$month%' OR Year like '%$year%'";
This Code Gives me accurate result for this kind of problem.
$sql= " SELECT * FROM dtr WHERE Course like '%$course%' AND Year_enrolled like '%$year_enrolled%' AND (Month like '%$month%' AND Year like '%$year%')";