datum selecteren van 10 dagen geleden

  $qGetOrder = mysql_query("SELECT order.date AS date,
                            order.order_id AS oorderid,
                            contracts.order_id AS corderid
                            FROM `order`
                            INNER JOIN contracts
                            ON order.order_id = contracts.order_id
                            WHERE order.date = NOW() - INTERVAL '10 DAYS'") or die (mysql_error());

$qGetOrder = mysql_query("SELECT order.date AS date,
                            order.order_id AS oorderid,
                            contracts.order_id AS corderid
                            FROM `order`
                            INNER JOIN contracts
                            ON order.order_id = contracts.order_id
                            WHERE order.date = NOW() - INTERVAL '10 DAYS'") or die (mysql_error());

DATE_SUB(NOW(), INTERVAL 10 DAY);

DATE_SUB(NOW(), INTERVAL 10 DAY);

NOW() - INTERVAL '10 DAYS'

NOW() - INTERVAL '10 DAYS'