How does mysql have historical record effect?

This is it. I have made an order system
Each order will have a date

But how can I let him assume that there are orders on 2016-05-05? If I can click on this date, all the orders on 2016-05-05 will appear?
As long as there are orders on that day, there will be orders on that day. Date display
PHP

Each order will have a date

As long as there are orders on that day, there will be orders on that day. Date display
PHP

Click on the time, query according to the time of the order, and list it.

<code>$sql = "select * from order where date =".$date;
$orders = mysql_query($sql,$conn); </code>