MYSQL CODE TO RETRIVE LAST ENTRY IN ASECENDING ORDER

Generally , we retrive mysql entry in asending and desending order. but after sorting  you want or need to sort query again .use the following mysql query.

SELECT  *
FROM    (
        SELECT  *
        FROM    mytable
        WHERE   topicid = $mytopicid
        ORDER BY
                id DESC
        LIMIT 20
        ) q
ORDER BY
        id

or, more efficiently,

(
SELECT  *
FROM    mytable
WHERE   topicid = $mytopicid
ORDER BY
        id DESC
LIMIT 20
)
ORDER BY
        id