How to sort user's info by date of arrival?

[roman78]

Hello everybody!,

As a mysql newbie, I'm having a problem because of my lack of knowledge of sql.

Let's me explain; I have an email form which sends the user's info directly to a table that storage the name, email, subject, message, and the time it arrived. I need to create a form report which let me know mails that arrived either today, yesterday, or even one week ago.

I would like to know how to query the database to display the user info by date of arrival and display the result into a table.


I hope someone could help me!
Thanks you so much.

 

[r937]

select name
     , email
     , subject
     , message
     , arrival
  from daTable
 where arrival >=
       date_sub(current_date, interval 1 day)
order
    by arrival

gives you all messages for yesterday and today

r937.com | rudy.ca

 

[roman78]

thank you so much!
Have a great day!