Hello

I wanted to create in my web page a script that calculates how many hours/days/months ago something was uploaded to the database.

e.g.

I uploaded an ad to my site today at 08:00
now lets say its 10:00, so i want to have a text saying
"added 2 hrs ago"
lets say 3 days passed
"added 3 days ago"
and so on....

I tried something but couldnt get it to work.

any suggestions ?

Danny

so what did you try
have a look at the MySQL date/time functions in da manuel
MySQL :: MySQL 5.1 Reference Manual :: 11.6 Date and Time Functions

Hello there,

well thats the problem i didnt realy understand that...

what i did was....MANUALLY added a "date" column

then with php, set a variable for today

then subtracting ... stuppid i know!

well any help would be appriciated

Danny

select timediff(now(),mydatecolumn) as ElapsedTime from MyTable

then use column ElapsedTime

..of course you could do the same calculation in your front end, forget the sordid details in PHP