Select last 20 order by ascending – PHP/MySQL

by

First, select last 20 entries. Then sort them in ascending order. You can easily do this in a single query (with subquery):

select * from (
    select * from your_table order by id desc limit 20
) tmp order by tmp.id asc

More Related Contents:

  1. While loop inserts three times
  2. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in? [duplicate]
  3. regarding installation of php in windows
  4. save user images in MYSQL database by which method? [closed]
  5. Im trying to create some temporary tables in mysql using php
  6. How to apply bindValue method in LIMIT clause?
  7. Best way to INSERT many values in mysqli?
  8. Importing CSV data using PHP/MySQL
  9. Convert latin1 characters on a UTF8 table into UTF8
  10. php/mysql with multiple queries
  11. Notice: Array to string conversion in
  12. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  13. Find total number of results in mySQL query with offset+limit
  14. mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]
  15. PDO multiple queries
  16. Using strtotime for dates before 1970
  17. How to efficiently find the closest locations nearby a given location
  18. Turn database result into array
  19. How to set up entity (doctrine) for database view in Symfony 2
  20. Update query with PDO and MySQL
  21. (mysql, php) How to get auto_increment field value before inserting data?
  22. Trying to get property of non-object – CodeIgniter
  23. What is the type this string? a:1:{s:2:”en”;}
  24. PHP to store images in MySQL or not?
  25. UTF-8 character encoding battles json_encode() [duplicate]
  26. How can I pass an array of PDO parameters yet still specify their types?
  27. MySQL & PHP Parameter 1 as Resource
  28. MySQL GROUP BY and Fill Empty Rows
  29. mysql injection damages?
  30. MYSQL select a piece of a string and order by that piece

Leave a Comment