Query/date problem

[micmac]

Hi Guys,
I have the following query:

$query = "SELECT * FROM movie,movie_genre,genre WHERE movie.movie_id=movie_genre.movie_id AND movie_genre.genre_id=genre.genre_id AND genre.genre_parent='" . $_GET['id'] . "' AND $current_date <= new_release_date ORDER BY movie.movie_title";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
$movie_id = $row["movie_id"];
$movie_title = stripslashes($row["movie_title"]);
$movie_release_date = $row["movie_release_date"];

What do i need to do to this query inorder to get only those rows that are greater than the current date?
For example, if $movie_release_date = 2003-10-01 (thats the value in the D😎 and the current date is 2003-08-01 how do i only display the rows that have a date greater (or in the future) than the current date.

Cheers,
micmac

[ScubaKing22]

$query="SELECT*FROM blah WHERE blah='blah' AND current_date<=future_date";