Can I Display DB Info Based on the Selected Date?

Avatar
roshna
  • Answered
I have created a form using php,html and mysql.Now when I select a particular date in the form how to display the contents of that day visible?For example I have a calendar when I select a particular date I want to display all the details..How?
Replies 1
Avatar
0
Scott
Hello roshna,

Thank you for your question on database information displayed according to date. If your database tables have a date column, you can create a query that pulls information according to the date selected by calendar date. This would be in the WHERE portion of your query.

An simple example would look like this:
SELECT * FROM Orders WHERE OrderDate='2008-11-11'

Kindest Regards,
Scott M