MySQL : Has recently updated his profile help

[Mpe]

how do u display a user who recently updated his profiles ... like in facebook u find : XXXXX has updated his profile picture etc. etc ...

[arpanmukherjee1]

are u building a CMS ??

in the table where the profile infomation is stored. create a coloumn called "LastUpdated" with type dateTime

IMO that should be suffiient

[Garbage]

Originally Posted by arpanmukherjee1

in the table where the profile infomation is stored. create a coloumn called "LastUpdated" with type dateTime

IMO that should be suffiient

And while retrieving, sort descending on LastUpdated column.

[Mpe]

Thanks... but
actually i want to display the message like one week only ... and suppose no one updated their profile during the whole week ... the message would be a bit old after a week ... is there any way how i could subtract the current date with the LastUpdated time/date and if its less than 7 then display the message and vice versa..

[Garbage]

MySQL :: MySQL 5.5 Reference Manual :: 11.7 Date and Time Functions