Php / Mysql数据库日报

Question

I'm new in php/mysql. I'm creating a simple webpage showing tables/data from my database(wamp). My problem is I want this data I input in the database table to save daily and to show them by calling the specific date/time. I'm lost I need a little help to put me in the right direction. Than you somuch!!

Answer 1

Make sure your date_time field Datatype is timestamp.

If you want to show data from table using specific date/time, try it

SELECT field_name1, field_name2, field_name3 
    WHERE date_time_field= '2014-04-10 16:14:54' 
    ORDER BY date_time_field DESC