[SOLVED] Different kind of timestamp

[micknc]

I have a php that calls a spreadsheet to display.  That spreadsheet is updated frequently and I need to write a code that would display a timestamp for the spreadsheet.  I thought it would be easy but so far no luck.

Any ideas?

Thanks,

Mick

 

[mmarif4u]

1st store datetime in db using timestamp then try

to retreive it with

 

select DATE_FORMAT(datetime, '%d-%m-%Y  H:i:s ') as formatteddate
echo "<td>" . $row['formatteddate'] . "</td></font>";

[micknc]

I keep looking after I posted and found:

http://www.phpfreaks.com/phpmanual/page/function.filemtime.html

 

That works well with external files.  I had to modify my spreadsheet to html but it will work for the long term.

Hopes this helps someone else searching.

Mick