I am running a PHP MySQL SQL query on a table, one of the tables has a date column named 'date'.
Example data stored is '26/12/2015 12:00 PM'
I am wanting to run a query to ORDER the search results in most closest date first.
If i store as Epoch time i can ORDER in ASC easily, but if i store as i have now it won't properly order.
How can tweak by SQL query to perform the required results?
$results = mysqli_query($link,"SELECT * FROM event ORDER BY date ASC") or die(mysql_error());
Hope someone can help?