php - How to sort data depending on what day it was posted? -

What data that you sort are stored in a MySQL database based on the days of the submitted data I went? ?

I basically want to prepare a diary that gives information every day of the week, depending on which day it was posted on the basis of date,

Som - Data as of date date - Mercury - etc.

Any code example and information will be great, thanks.

you some day

SELECT DAYOFWEEK (day of the day) in the form of day-to-day Can, date from day to day, date time;