无法从日期列中检索日期 - PHP Mysql

Question

Hi i am beginner in php, and i am try to retrieve the datas(between two dates from single column namely booking) from the table(billing_details) using the date column

below is the source code

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

echo $from; 

$sql = mysql_query("select * from billing_details where SRF ='$_POST[srf]' or Service_Type ='$_POST[service]' or Status ='$_POST[status]' or Branch ='$_POST[branch]' or DATE(`Booking`) between '".$from."' and '".$to."'");

 ![I have select two different dates to get datas between the selected dates , but nothing is retrieved, only the echo $from is retrieved the the selected date][1]


Kindly help me to solve this issue, Thanks in advance

Regards,
Abdul hameed

Answer 1

Your date format is incorrect and should instead be 'Y-m-d' or else mysql will not recognize it. Learn get used to that format :)

Also since you are a beginner be aware that you should check the strtotime return. Of it evaluates to false then the input is invalid and passing that to the date() function would result in 1969-12-31 i believe