Inserting a date

[freshtokyo]

Hey there fellas, I'm trying to set up a small website for myself that has the date (simple j,n,Y) of when I'm dj'ing, I built a little admin for it.

I have three input text boxes:

<?PHP
   $ThisYear = date("Y");
?>
Date: <input name="LineupMonth" type="text" size="2" maxlength="2"> / 
<input name="LineupDay" type="text" size="2" maxlength="2"> / 
<input name="LineupYear" type="text" size="4" maxlength="4" value="<? echo $ThisYear; ?>">

what I can't figure out is how (when inserting into the database) to make date (j,n,Y) equal the dates I've set.

I want to do this because I'd like to not worry about going in and manually removing the dates that have passed. You know? (I'll set up a little code to only display dates that equal today or in the future) Thanks!

[Technophile]

If you are using MySQL, the insert string would be something like this:

INSERT INTO table (lineupdate) VALUES ('2006-08-27');

The date needs to be year, month, day. Concatenate the values from the form with php before inserting into the db.

Something like:

$lineupdate = $year . '-' . $month . '-' . $day;

or in other words

$lineupdate = $_POST['LineupYear'] . '-' . $_POST['LineupMonth'] . '-' . $_POST['LineupDay'];

Assuming you're using post for the form.

Then put the lineupdate variable in your sql string:

$sqlstring = "INSERT INTO table ('lineupdate') VALUES ('" . $lineupdate . "');"

Something like that. That's one way anyway.