I want to make a statement that pretty much says this $selecttourdates = "SELECT * FROM bryan WHERE tourdate > todaysdate ORDER BY tourdate;";

but I am using timestamps.. here is what I used later down the script to convert the timestamp...

$eventdate=date("l, F jS",mysql_result($result,$i,"tourdate"));

so how can i make it so it will only show tourdates that are today's date and onward.. not before today's date?