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.