Welcome to WebmasterWorld Guest from 54.196.232.162

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

manipulating with date type input

mysql php

     
12:18 am on Feb 2, 2008 (gmt 0)

Junior Member

5+ Year Member

joined:Nov 21, 2007
posts: 54
votes: 0


Hello,
I have a text field in which the users enter date in yyyy/mm/dd format. I get the value and put it in mysql query.
My concern is, i want to compare the data with previous month as well...

So if the user enters 2007/12/01, i will display data for dec 07. Now i want to compare dec 07 data with nov 07 data as well. So how can i calculate the previous month from the input?

Thanks!

3:49 am on Feb 2, 2008 (gmt 0)

New User

5+ Year Member

joined:May 13, 2007
posts: 26
votes: 0


Try this, I didn't use comments because the variables seem pretty self-explanatory.

<?php
$date = "2007/12/01";
$datearray = explode("/", $date);
$month = $datearray[1];
echo("This month is ". $month . "<br>");
$lastmonth = $month - 1;
echo("Last month was " . $lastmonth);
?>

Just be careful that if the month is January, this will calculate last month as 0 (not 12). An if statement or two will take care of that.

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members