javascript - php data between two dates for specific person -

i retrieve data between 2 dates problem retrieve data between 2 dates specific person used this working when retrieve data between dates did not work when use dphone means specific doctor phone number

$result = mysql_query("select * checker date between '$fromdate' , '$todate' , dphone='$splist'" 

i want retrieve data dphone match suggestion please can retrieve data according need

try instead:

select * checker dphone='$splist' , date between '$fromdate' , '$todate' 

also, sure value in "dphone" field doctor you're trying get, matches $splist exactly?