SQL query for date

[djavet]

Hello,

I'm not a php/mysql master, but I wish to retrive the date (created and lastmodified) of a article and put into a module in the footer.
How can I make this?

Many thx for your help and time.

Regards, Dom

[emergence]

example: http://www.contenido.de/forum/viewtopic ... t+modified

the module shows the last modified date and the author of the article...