Welcome to WebmasterWorld Guest from 188.8.131.52
Id like to query a MySQL database with PHP but tell it to start querying from the last record and go backwards.
I know how to get the last line from a query, but this database may be very large, and the data that is needed will always be newly entered info, thus, at the end.
select * from mytable where field like '%blah%' order by ID desc limit 0,30
The limit parameter will also help you limit how many rows are returned, saving a bit of resources.
Hope this helps!