Display data from Mysql based on date

Question

I am making a table to display data from a MySQL database, this table will display all the information for the current date but next day it will be blank again and contain no information so you can see the information only for the current day, the data will exist in the database forever however and all data can be displayed upon request!

Now you know my goal i will present the problem, i dont know how to display information for only the current day in the table.

score 1 · Accepted Answer · answered Apr 20 '15 at 10:51

1

Use data_date=CURDATE() in where condition of your select statement. data_date is your date field separating data for each date...e.g

select * from mydata where data_date=CURDATE()

this will only give the current date data as required

answered Apr 20 '15 at 10:51

lakshman

656
4
18

Thank you, simple and answered my question =) – Kenziiee Apr 20 '15 at 11:01

score 0 · Answer 2 · edited May 05 '21 at 05:46

0

A quick search will bring up similar questions, with answers. However you can use PHP's date() formatter.

Display data from Mysql based on date

2 Answers2