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

Reply content:

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

Time list page, group according to time, list the time when there are orders.

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>