Hi,
You can get rows from the end using LIMIT. But depending of what you really want to do, get, you will have to order your data:
SELECT * FROM Table LIMIT 1, -1
LIMIT offset, number of rows
if number of rows is -1, then offset is the number of rows to get from the end
But the most logical way is to ORDER your data, getting the last row doesn't really mean anything. Getting the most recent entry giving a data means something:
SELECT * FROM Table ORDER BY EntryDate LIMIT 1
LIMIT number of rows
Get 1 row that is the oldest entry (ORDER BY not ORDER BY DESC).
JM
