SELECT * FROM base WHERE Date(srok) BETWEEN date('now') AND date('now','+10 day') ORDER BY srok

SELECT * FROM base WHERE srok BETWEEN date('now') AND date('now','+10 day') ORDER BY srok