I have a database with a listing of events. I do not want to include events that have already happened, so I want to query the db for events from the current date going forward. I have tried a number of things but it is not working. Here is what i have so far - in the query
// Get the current date
$Now = time();
// Make a MySQL Connection
mysql_connect("localhost", "*****", "****") or die(mysql_error());
mysql_select_db("******") or die(mysql_error());
// Get all the data from the table
$result = mysql_query("SELECT * FROM events where Date > $Now order by Date ASC Limit 0,10")
or die(mysql_error());
Any help would be appreciated.
Cheers,
Chris