InMotion Hosting Support Center

Can I Display DB Info Based on the Selected Date?

Category: Databases

roshna
Asked:
2017-02-03 8:12 pm EST

Hits: 23
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.

OTHER ANSWERS

0

scott
Staff
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, Click the button below to be taken to the login page.

Need more Help?

Search

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: support@InMotionHosting.com
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!