Topic awaiting preservation: display date of last mysql table addition (Page 1 of 1)

i have a website based backed by an mysql database and I'd like it to display the "last updated" date on the main page. since the database is merely used for generating a list table it probably shouldn't be too hard. the database entries don't have dates.

how can i do this? (in php preferably)

Cheers

<´¯`·.¸ Patric ¸.·´¯`>

I'm not aware of the date being stored, so I don't think it's possible. You'd need to modify the table to include a date field, and handle appropriately.

Yep, just add a "datetime" field to the table, and whenever you do an INSERT or UPDATE query, use the SQL function NOW() to generate the date. Like, "INSERT INTO table (id, content, datetime) VALUES ($variable1, $variable2, NOW())" Edit: fixed syntax

Then, to get a "last updated," "SELECT MAX(datetime) as datetime FROM table". The SQL result column "datetime" will contain the table's highest (most recent) value of that field.

[This message has been edited by Perfect Thunder (edited 10-29-2002).]

thanx guys,

I'll add a date field and see how that goes...

<´¯`·.¸ Patric ¸.·´¯`>

Moving this to the server-side forum............

___________________
Emps

FAQs: Emperor