[SOLVED] Timestamp table in database

[rkstevens]

I have a timestamp table in my database, which gets a new record added at certain modification times. the timestamp is the only field in the table, and is the primary key.

 

I have tried the query: "SELECT * FROM Updated ORDER BY 'Update' DESC LIMIT 1" which would (in my mind) return the highest (or most current) timestamp. Unfortunately, it does not, and just returns the first record in the table. Adding or removing the 'DESC' does not change this; neither does removing the 'LIMIT 1'.

Not sure what I am doing wrong.

 

[PFMaBiSmAd]

Remove the single-quotes from around 'Update'. Single-quotes make it a string, not a column name.

[rkstevens]

$update_query = "SELECT * FROM Updated ORDER BY Update DESC LIMIT 1";
$update_data = mysql_query($update_query)
or die("Error in accessing database: Update");

without the single quotes around 'Update' I get an SQL error

 

[teng84]

update is reserve words so you should use back ticks on it 

 

select * from `update`

[rkstevens]

That works!

Thank you.