InMotion Hosting Support Center

Can I Display DB Info Based on the Selected Date?

Category: Databases

2017-02-03 8:12 pm EST

Hits: 24
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?

You must login before you can ask a follow up question.

You must login before you can submit an answer.



43,761 Points
2017-02-05 7:00 pm EST
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

You must login before you can post a comment about this answer.

Like this Question?

Support Center Login

Our Login page has moved. Please click the button below to be redirected to the login page.

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!