Date Diff problem

Hello there

I've used many ways but i can't find the solution,my date is stored in a "date" mySql field.
I want to display full article in 4 four months time after inserted.

Code:

---

...
$art_query=mysql_query($getarticles);
        $n=0;
        while ($array=mysql_fetch_array($art_query)) {
                                               
$ids[]=$array["id"];                                                                                           
$date_published[]=$array["date_created"];                                               
....
//Results of query are in an array i think this makes it all hard
$mydate=$date_published[$n];

 //$mydate->modify("+4 month");tried this too , srttotime,getdate...
// print $now;

$now  = mktime(0, 0, 0, date("m"),  date("d"),  date("Y"));
$pub_date =mktime(0, 0, 0, $mydate[month]+4, $mydate[day], $mydate[year]);

                if ($now > $pub_date){
                        echo "something";
                                                                                       
                }else{
                        echo "something else";
                                                                                       
                        }
 }

---

$n++
something is wrong with my syntax in $pub_date i guess because when i echo it displays 1-31-2000 which is not really my date record....

$now works offcourse

:eek:

What do you get if you echo out $mydate[month], $mydate[day] and $mydate[year] prior to mktime()? What are those values? Further, what is $array["date_created"] when echoed?

$array["date_created"] echoes the correct dates for every record ;

echo $mydate[day]; echo $mydate[month] == 2 !!!
don't know where this 2 comes from

do you know the correct format for the mkdate i need to write?

thanks a lot

execute the following, and then let us know what is returned:

PHP Code:

---

<?php print_r($mydate); ?>

---

it doesn't sound like $mydate is even an array, so you can't just refer to it like you are ($mydate[day], etc).

I think you may be misunderstanding the concept of mysql_fetch_array() in a while loop. When you use it like you're using it, each loop is a new row of the record set that was returned by the database. $array["date_created"] does not contain an array of every "date_created" value in the record set; instead, it contains the single "date_created" value for the row you're currently looping on. Same goes for $array["id"], or anything in your $array collection.

print_r($mydate); is correct for every record
Samba i need the difference of each record individualy so i m gettin each new row

a bit confused.. i could use mysql_fetch_assoc() but i need to do it this way, stupid i know

saying that it is correct does not help us. that's why I said you should post what it returns...

:/

2009-09-21

2009-09-18

uhh. that is not the format print_r() prints out in. if you want to be helpful, just post whatever was output.

PHP Code:

---

$getarticles="SELECT* FROM InArticlesManagment where issue_id ='$id'";
    $art_query=mysql_query($getarticles);
    $n=0;
        while ($array=mysql_fetch_array($art_query)) {
            $titles[]=$array["title$lang"];           $date_published[]=$array["date_created"];
$ids[]=$array["id"];                                               

$mydate=$date_published[$n];
print_r($mydate);
....
.... 


---

oh yes it prints the date field like i told you
...:sick:
i m trying mate
thnx

... lol.

I am asking what gets output when you run the print_r(). and I mean, I want you to run it, and then copy and paste the part from the print_r(), and then post it.

that's ALL.

print $mydate;
print_r $mydate;

output

2009-10-21

:confused:

As said previously, $mydate is not an array in this scenario, so print_r() is not printing an array. Here, try it like this...

Code:

---

$art_query=mysql_query($getarticles);

while ($array=mysql_fetch_array($art_query)) {
           
  $id = $array["id"];                                                                                           
  $mydate = explode("-",$array["date_created"]);                       
 
  $now  = mktime(0, 0, 0, date("m"),  date("d"),  date("Y"));                       
  $pub_date = mktime(0, 0, 0, $mydate[1]+4, $mydate[2], $mydate[0]);

  if ($now > $pub_date){
    echo "something";           
  }else{
    echo "something else";             
  }
}

---

Though, with your sample date - "2009-10-21" - then $mydate[1]+4 is 14, and that may not work in mktime() anyway...

mktime() is smart and will make up for it.

anyway, "print" is not "print_r()"! since you already stripped some code out of the stuff you've been posting, I had no idea what you might have done to create an array.

thanks Samba,kows
had the apocalipsis with explode() earlier

hm, mktime wont do us the favor i guess

which function could do the increament we need in the current format
do i need to change the field to datetime?..

any suggestions?

as I said in my last post, mktime() will figure out the correct time when given a month of 14 or even a day of 32, for example. this is all documented on PHP.net, as well. the above example given by SambaNeko would work just fine.

You're trying to get rows in the database that are less than 4 months old, correct? If you don't need the rest of the rows, then I'd just make MySQL deal with it...

Code:

---

$getarticles = "SELECT * FROM InArticlesManagment WHERE issue_id ='$id' AND date_created >= DATE_SUB(curdate(), INTERVAL 4 MONTH)";

---

I think that would work, but haven't tested it myself...