Highlight newest added items

[ralphiooo]

Hi, i store the date i insert items into the database using unix timestamps. For my logged in users i need to highlight newest added items since there last visit. I was wondering what's the logic behind this and the easiest way of implementing this. I had a shot but my brain couldn't handle it.

Appreciate the help. Thanks

 

[jpadie]

assume:
1. you want the three latest additions
2. the timestamp is called "tmstamp"

$sql = "Select * from $table order by `tmstamp` desc limit 3";

this will just return the last three

if you want the entire set returned then remove the limit clause. then as you iterate through the recordset keep a counter and highlight (use a css declaration) the first 'n' rows that are returned.