[Resolved] If problem

NZ_Kiwis

<?php 

mysql_connect ;
mysql_select_db 
$result = mysql_query ("SELECT * FROM date_test where id = '3'"); 
while ($row = mysql_fetch_array($result)) 
{  

$date = $row[date]; 
$newdate = date('d F', strtotime($date)); 
$date = $row[date]; 
list($d3, $d2, $d1) =  explode('-', $date);


$testtime = strtotime("$newdate");
$nowtime = strtotime("now");

if ($testtime < $nowtime) {
date ('d M Y', $row["timestamp"]); 

} else {
echo "No";
}
}
?>

in my if statment... how does it read is testtime greater than nowtime or is it nowtime greater than testtime????

planetsim

What is this doing in particular

date ('d M Y', $row["timestamp"]);

Its located just under the first if Statement, and is getting any output.

if ($testtime < $nowtime) {

Is $testtime set in the past or future? As the if statement will run if $testtime is less than $nowtime if not the else should run.

NZ_Kiwis

Originally posted by planetsim
What is this doing in particular
date ('d M Y', $row["timestamp"]);
Its located just under the first if Statement, and is getting any output.
if ($testtime < $nowtime) { 
Is $testtime set in the past or future? As the if statement will run if $testtime is less than $nowtime if not the else should run. [/B]

First point... forget it.. just replace it with say a

echo "$test";

$testtime could be future or past.. that's why i'm doing a if.. to see if it's before the "now" date or after... if it is before then i want it to print if not then

echo "No";

bradgrafelman

Are you using Unix timestamps?

if ($testtime < $nowtime) { 

echo 'testtime is before nowtime';

} elseif ($testtime > $nowtime) { 

echo 'testime is after nowtime';

} else {

echo 'testtime IS nowtime';

}

NZ_Kiwis

Originally posted by bradgrafelman
Are you using Unix timestamps?

if ($testtime < $nowtime) { 

echo 'testtime is before nowtime';

} elseif ($testtime > $nowtime) { 

echo 'testime is after nowtime';

} else {

echo 'testtime IS nowtime';

}

[/B]

my stored time is date format in my mysql table YYYY-MM-DD and I convert that into strtotime as seen in my code... i then match it against the strtotime now time....

bradgrafelman

Alright.. then that code should work fine.