...

View Full Version : posting updated date



emerald511
11-20-2007, 05:19 AM
is there a php code that posts the date that the database was last updated?

Fumigator
11-20-2007, 06:31 AM
Are you asking about any row in the database being updated, or a single row in the table being updated? (The answer is no on the second option-- you must add a timestamp column to your table(s) to track the last update; there may be a way to do it on the first option)

Also it helps to provide basic info such as the database you are using (i.e. MySQL).

emerald511
11-21-2007, 03:42 AM
to clarify i am using a mysql database and i want the time to be updated every time there is a row added to one of the tables.

also is there a page that fully explains the different types of fields in a database?

Velox Letum
11-21-2007, 03:44 AM
A time updated that any row is updated? Well, instead of making a separate table for the status of the last update, you can query the table with the rows sorted descending on the date column and use the latest insert/update date. Not too difficult. e.g.


SELECT * FROM news ORDER BY updateTime DESC LIMIT 1

And use updateTime as the "latest update"

emerald511
11-21-2007, 04:11 AM
oh well i don't want to change the order i want there to be a thing that says table last updated: and has the date that the most recent row was added

Velox Letum
11-21-2007, 05:07 AM
It doesn't change the order. It's the order it retrieves the data in this particular query.


SELECT updateTime FROM news ORDER BY updateTime DESC LIMIT 1

Will select the time of the latest updated row if your column for updated time is updateTime.

emerald511
11-22-2007, 03:53 AM
<?php $query="SELECT updateTime FROM members ORDER BY updateTime DESC LIMIT 1" echo $updateTime ?>

I'm extremely new to php and thats the code i put on the site but its not working

Velox Letum
11-22-2007, 04:27 AM
I assumed you knew how to use MySQL databases with PHP.

Check out http://www.php-mysql-tutorial.com/ and other tutorials around the internet, or buy a book.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum