Iam trying to display the date which is greater than the current date.for that have written the code like below
$todaydate = date("d/m/y");
SELECT * FROM `jos_supplier_order` where due_date >"'. $todaydate.'";
It is giving the results like greater than the date only but it is not considering the month and year.if the d-- date is greater then it is displaying.It has to consider the month and the year also .
Is there any solution for this?