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

MySQL : Has recently updated his profile help

Mpe

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:
OP
M

Mpe

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