• CONTEST ALERT - Experience the power of DDR5 memory with Kingston Click for details

MySQL : Has recently updated his profile help


Broken In
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
Last edited:


Broken In
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..
Top Bottom