MySQL : Has recently updated his profile help

5 posts · originally from https://geek.digit.in/community/threads/mysql-has-recently-updated-his-profile-help.138536/

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

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

arpanmukherjee1 said:
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.

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..

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