[Resolved] Select Date statement

[nikko50]

Hi guys! How can I structure my SELECT statement so I get all records from current date and forward??

$query="SELECT * FROM customers ORDER BY 'orderdate'";

[zapa]

$query="SELECT * FROM customers ORDER BY orderdate";

use ` insted of '

[devinemke]

SELECT * FROM customers WHERE date >= CURDATE() ORDER BY orderdate