show page between two dates

[knighthawk1337]

I run a lan party website. I want to be able to close down the registration automatically. What i want to do is enter the date of the lan party into an sql database which i have already created. Then i want to be able to enter how long before that date that the page should be available. I'm not sure how to do this or even if its possible with php. I hope someone here can help me.

[LordShryku]

It's possible. Common. And fairly easy. Once you have the database setup, you just query it for the "expiration date", and use a conditional to see i it's expired yet. This should get you going in the right direction

/* Connect and select DB */
$conn   = mysql_connect("username","password","server");
          mysql_select_db("database", $conn);

/* Run the SQL query */
$sql    = "SELECT expiration_date 
           FROM   table 
           WHERE  lan_party = 'something'";

$result = mysql_query($sql) or die(mysql_error());
$row    = mysql_fetch_array($result);

/* Generate current timestamp
   and timestamp for expiration date 
*/
$today = time();
$expired = strtotime($row['expiration_date']);

if($today > $expired) {
   /* Date expired. Don't let them sign up */
}
else {
   /* Not expired. You can sign up */
} 

[knighthawk1337]

wow i was thinking in the opposite way. I was worried about it showing up but it looks easier worrying about it not showing up the way you did it. (if that makes sense) ok but the day after the lan party i want it not to show again. how can i do that then automatically?