do not display expired events

[bradkenyon]

i am trying to only display the events that are not expired.

 

i was thinking that i could do an if statement within the loop, testing if the date is less than the current date, then do not display.

 

any help would be appreciated.

while($row = mysql_fetch_array($result))
{
	$i = 0;
	$t = 1;

	while($i <=0)
	{
		if($row['expiredate'] > date("Y-m-d",time()))
		{
			print '<li><strong>'.date("m/d/y",strtotime($row['expiredate'])).'</strong> - ';
			if($row['moreurl'] != '')
			{
				print '<a href="'.$row['moreurl'].'" target="blank">'.$row['subj'].'</a> - '.$row['location'].'';
			}
			else
			{
				print $row['subj'].' - '.$row['location'];
			}
			print '</li>';
			$i++;
			$t++;
		}
	}
}

[rhodesa]

Wouldn't it be better to filter them out on the SQL level? What is your SQL query?

 

Should looks something like:

SELECT * FROM events WHERE expiredate > NOW()

[bradkenyon]

PERFECT!

 

Thank you.

 

 

[cooldude832]

if the experidate holds the time they expire then it should be less than the current time "NOW()"

 

that query as given will expire all events that expire after "NOW()" instead of all expiring before "NOW()"

[bradkenyon]

I'm looking for the event to stay until 11:59pm of that date, so people can see what happened that day, even if the event was over for a couple hours.

[cooldude832]

I'm looking for the event to stay until 11:59pm of that date, so people can see what happened that day, even if the event was over for a couple hours.

 

then your field expiredate should be adjusted to equal 11:59:59 of the day you want to expire so that NOW() won't trap em.

 

Or

you can avoid NOW() and use php's mktime function to make it 11:59:59 of today

[bradkenyon]

anyway i can modify NOW() to add a day to NOW() so it will include a 4/10 on the day it is 4/10?

[cooldude832]

anyway i can modify NOW() to add a day to NOW() so it will include a 4/10 on the day it is 4/10?

 

say what? Subject verb object can't translate?

[bradkenyon]

As you mentioned before, w/ the query

 

SELECT * FROM events WHERE expiredate > NOW()

 

is there anyway you can modify the query so it displays the event that has the same date, for example....

 

Red Cross Blood Drive 4/10/2008

 

Today's date is 4/10/2008.

 

I want to display that event until the day is over, I was thinking you could modify the query like this...

 

SELECT * FROM events WHERE expiredate > NOW() + 1

 

or

 

SELECT * FROM events WHERE expiredate >= NOW()

 

[bradkenyon]

got it, set it to be 23:59:59.

[rhodesa]

Do what works for you, but in my opinion, if you want the Blood Drive to be displayed all day on the 4/10/2008, it would expire technically on 4/11/2008.