$query1="select * from games";
...and then some inserting into the js table
one of the table columns i have is the game_date.
i want to get it so that games that have already happened are no longer in my js table
i want a query something like:
$query1="select * from games WHERE current_date > game_date";
does my game_date have to be of time type?
does it need to be in a specific format?
is there a php function that gets the current date?
how should i go about comparing these 2 dates - i'm a total n00b