php - mysql query to fetch details of users between specific dates -

$query="select distinct ind_id,indentdate,submitted_by          raiseindent          submitted_by='$nm'            , indentdate between '$fromdate' , '$todate'            or indentdate between '$fromdate' , '$todate'            or submitted_by='$nm'"; 

here $nm username

i not getting errors, query fetching records if use $nm (user name) or between 2 dates

if use serach specific user name , 2 dates fetching users records between selected dates

i need specific results entered user name in username field serach

try this

$query="select distinct ind_id,indentdate,submitted_by          raiseindent          submitted_by='$nm'            , indentdate between '$fromdate' , '$todate'"; 

i dont think need more complicated this.

or if possible $nm empty or dates empty tests in php , dynamically build query accordingly rather trying sql you

$sql = 'select distinct ind_id,indentdate,submitted_by      raiseindent      ';   if ( !empty($nm) && $nm != 'all' ) {     $sql .= "submitted_by='$nm' , "; } if ( !empty($fromdate) && !empty($todate) ) {     $sql .= " indentdate between '$fromdate' , '$todate' "; } $sql = rtrim($sql, 'and ');