date() problem

[stew]

hey there,

im trying to recall entires from a database that have an associated date with them. i only want dates to be recalled that occur in the future. the following code is what i have already, but im not too sure where to go from here

$month = date("F");
$day = date("jS");
$year = date("Y");

$SQL = " SELECT * FROM gigs ";

$gigdate = date(F jS, Y);
$date = $month $day, $year;

$SQL = " $SQL . WHERE date >= '$gigdate' ";

where the $gigdate (stored in the database) is obviously the date of the gig and the $date is the current date. so $date has to be after $gigdate.

im not too sure where to go from here, so any ideas are welcome... thanks!

[hand]

If date field is of type DATE, DATETIME or mysql-TIMESTAMP the simpliest query is:

$SQL = " SELECT * FROM gigs ";
$SQL = " $SQL . WHERE date >= now()";

or

$SQL = " SELECT * FROM gigs ";
$SQL = " $SQL . WHERE date >= curdate()";