Date problems :(:(

jonsof

i want to use date() or another function and calcualte the date d, m, y
just a month ago.

I tried (date("m")-1)=0 😕 😕
I expected to receive 12 🙁🙁

stolzyboy

$today = getdate();
$month = $today['mon'];
$mday = $today['mday'];
$year = $today['year'];

jonsof

i put
$month = $today['mon']-1=0 and not 12 🙁

Is there any fault?

stolzyboy

of course it would equal zero, the number 1 - 1 = 0, it won't actually give you 12, but you can use 0 as 12 if need be, if you want words, just use if's or switch's

<?
if ($month == "1")
{
$month_name = "January";
}
else if ($month == "2")
{
$month_name = "February";
}
else if ($month == "3")
{
$month_name = "March";
}
else if ($month == "4")
{
$month_name = "April";
}
else if ($month == "5")
{
$month_name = "May";
}
else if ($month == "6")
{
$month_name = "June";
}
else if ($month == "7")
{
$month_name = "July";
}
else if ($month == "8")
{
$month_name = "August";
}
else if ($month == "9")
{
$month_name = "September";
}
else if ($month == "10")
{
$month_name = "October";
}
else if ($month == "11")
{
$month_name = "November";
}
else if ($month == "0")
{
$month_name = "December";
}
else
{
}
?>

jonsof

I put the following code

result=mysql_query("SELECT postid, title, post, DATE_FORMAT(date_posted, '%e-%m-%Y')AS date_posted  FROM post WHERE now() BETWEEN date_posted AND expire_date ORDER BY postid DESC");
...
...
$day=date("j");
$month=date("m")-1;
if($month==0) {$month=12;}
$year=date("Y");
$crucial_date=$day."-".$month."-".$year;
...
...
...
while($row=mysql_fetch_assoc($result)) {
...
....
....
if(($row['date_posted']>=$crucial_date)&&($crucial_date>=$date_before)) {echo "<hr>";} 
....
$date_before=$row['date_posted'];
}

and the result is :

the <hr> is placed between 3-01-2003 and 7-01-2003 🙁🙁
I expected to get placed between 29-12-2003 and 3-01-2003

But when i uploaded this script on Tripod it didn't work. The <hr> wasn;t between 3-01-2003 and 7-01-2003 as in my localhost.

What occured this failure?

keith73

Originally posted by jonsof
i want to use date() or another function and calcualte the date d, m, y
just a month ago.

I tried (date("m")-1)=0 😕 😕
I expected to receive 12 🙁🙁

have you tried mktime
http://www.php.net/manual/en/function.mktime.php

$today = getdate();
$newDate = strftime("%m-%d-%Y",mktime(0,0,0,$today['mon']-1,$today['mday'],$today['year']));

stolzyboy

well then simply if it comes up with zero, rewrite it to say 12,

if ($mon =="0")
{
$mon = 12;
}

jonsof

Yes, now the point is the comparisons between dates 🙂

As you can see in my script above, i don;t receive the result i expected