mysql timestamp manipulation


Posted on 16th Feb 2014 07:03 pm by admin

How could I use a timestamp (e.g 2009-10-30 13:20:35 ), and with php find out if it is:

from today
from this week
from this month
from the last 3 months
from the last 6 months
from this year
from 1 year ago
etc etc

?

Thanks

No comments posted yet

Your Answer:

Login to answer
216 Like 11 Dislike
Previous forums Next forums
Other forums

elseif help!
OK so I'm new to the site, as well as PHP altogether (Trying my hand at managing an online RPG) and

Is it possible to stop reservation creation in PM Order?
Hi All,

Is it possible to stop reservation creation in PM Order?

Thanks in adv

Allowing ' and "
Hello everyone,

I am creating a form where users submit information to go into a database. I

help with Get_
ok some how this is not working i am not sure what i am doing wrong here but what this does is when

styling a RadioButtonList
HiI need to have a radio button and close to it, its lable, then a space then another set of those.

mysql_real_escape_string making variable equal nothing
i post a form and i post the variable:
Code: $var = $_POST[variable];then i echo $var its what i

array_count_values question?
ok i'm trying to create a top ten list from a database of listed favorite movies.

the followi

Nested (echoed) php running wrong script
Got a problem with a php website I'm creating.

In a nutshell, the first page is entirely html

problem with sql querry in php script
Hello guys,

What I want to do is I want to read out a csv file and then but te conent ot the

Best way to read this text file.
Hi.I am planning to make a small application in C# to convert the players from Football manager 2010

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash