I am doing a project where i have to fetch data of between dates plus the name of user. The query for only date betweenis working fine but with and operater its going in wrong way so please suggest me how to implement it to achieve desired output. this is my code:
$qry11=mysqli_query($con,"select * from entry where (create_date between '$first' and '$second') && cnor='$nme'");
so please suggest ne how to do this....any idea will be appreciate with highly gratitude.
&&
should be replaced with
AND
You seem to be already using AND in your query right
(create_date between '$first' and '$second')
use the query like below
$qry11=mysqli_query($con,"select * from entry where (create_date between '$first' and '$second') and cnor='$nme'");