display links dependant on date

[Anon]

Hi,

This is very basic, but I'm new to PHP/MySQL, so any pointers would be
gratefully received..

I want to hold a table of fixtures in mySQL, of which one of the fields
would be a future date, and another would be a url.

I'd like to be able to display the url for the 'forthcoming' fixture on my
php page, presumably by testing the date field with today's date... but
I'm not sure how to do it?

TIA

Solfer

[Anon]

You can use PHP time() function to obtain the actual number of seconds since 1-1-1970. So, say you want to check it each hour. You would save the URL and the result of the time() function on the table. Then, after retrieving, do the following:

$Now = time();
$Before = mysql_result($query,0,"time");
$Compare = $Before + 3600; //1 hour

if($Now > $Compare){
show_url;
}else{
not_yet;
}

hope it helps

fLIPIS

[Anon]

most definitely!

Thanks fLIPIS.

[Anon]

Actually fLIPIS, sorry if this is obvious, but how do I save the result of the time() function in my table?

S