Date Diff problem

[xxronis]

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.

...
$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

[SambaNeko]

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?

[xxronis]

$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

[kows]

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

<?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).

[SambaNeko]

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.

[xxronis]

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

[kows]

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

:/

[xxronis]

2009-09-21

2009-09-18

[kows]

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

[xxronis]

$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
...
i m trying mate
thnx

[kows]

... 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.

[xxronis]

print $mydate;
print_r $mydate;

output

2009-10-21

[SambaNeko]

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

$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...

[kows]

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.

[xxronis]

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?

[kows]

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.

[SambaNeko]

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...

$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...