Mysql query return wrong result set

Hi,

    Dear pass your date format according to your database from jquery request.

Thanks for

 

Packiaraj Santhiyagu actually i have a table in which i have two columns previously there data type was varchar but i change it to date now , Now when my below query executes it shows the records of 2018-09-05 the format is year-month-day , but the query return the rows of 2018-05-09 also i do not know why i can share my project with you if you can give me email to connect with my machine below is my query. and table snapshot.

 

function datevisereport()

{

global $tprefix,$con;

$data='';

$grandtotal=0;

$start_date= date("Y-m-d",strtotime($_POST['start_date']));

$to_date = date("Y-m-d",strtotime($_POST['end_date']));

$query="SELECT aid,glid FROM plan_vdetails WHERE location=".$_SESSION['role']." and vdate2 BETWEEN '".$start_date."' and '".$to_date."' group by aid,glid";

echo $query;

echo("
");

$vouceher=mysqli_query($con,$query);

while($getvoucher=mysqli_fetch_array($vouceher))

{

$acamount=0;

$vdquery='select * from plan_vdetails where location='.$_SESSION['role'].' and aid='.$getvoucher['aid'].' and glid='.$getvoucher['glid'].' and vdate2 between "'.$start_date.'" and "'.$to_date.'"';

echo($vdquery);

echo("
");

$vdetails=mysqli_query($con,$vdquery);

while($getvdetails=mysqli_fetch_assoc($vdetails))

{

if($getvdetails['transtype']=='DR')

{

$amountdr=$getvdetails['amount'];

$amountdcr=0;

}

else

{

$amountdcr=$getvdetails['amount'];

$amountdr=0;

}

if($getvdetails['isrectify']==1)

{

$bgcolor='bgcolor="yellow"';

}

else

{

$bgcolor='';

}

$data.='

'.$getvdetails['vdate2'].'

'.getSingleValue('voucher','voucherno',' where id='.$getvdetails['vid']).'

'.$getvdetails['glid'].'-'.getSingleValue('accounts','account_no',' where id='.$getvdetails['aid']).'
'.$getvdetails['description'].'_'.getSingleValue('employees','fullname',' where id='.$getvdetails['claim_person']).'

'.$amountdr.'

'.$amountdcr.'

'.$getvdetails['rbalance'].'

';

$acamount=$acamount+$amountdr;

}

$grandtotal=$grandtotal+$acamount;

$data.='