Select different dates from mysql
Please use yyyy-mm-dd to avoid confusion (mm-dd-yyyy vs dd-mm-yyyy) and be consistent with MySQL.

Does this give you the first item you want?

SELECT *
    FROM tbl
    WHERE ts &lt; CURRENT_DATE()
    ORDER BY ts DESC
    LIMIT 1;


If so, does this give you the other two:

SELECT *
    FROM tbl
    WHERE ts &gt; $foo
    ORDER BY ts
    LIMIT 2;


given that $foo is the timestamp you got from the first query.

I assume your ts is of datatype TIMESTAMP, not INT.  DATETIME would also do.

If you need to display dd-mm-yyyy, use DATE_FORMAT in the SELECT, but not for internal calculations.