Return the latest 10 records from a mysql query [closed]

by

I’m assuming your table has an id column as the primary key with auto increment.

In which case, you need to add an ORDER BY and LIMIT to your query.

$q = mysql_query("SELECT name from films WHERE name LIKE '$name' ORDER BY id DESC LIMIT 10") or die(mysql_error());

ORDER BY id DESC will make your query put the latest records first.

LIMIT 10 will ensure that you only grab 10 records.

More Related Contents:

  1. Trying to Show 87 mysql rows in 3 html tables using PHP and mysql [closed]
  2. While loop inserts three times
  3. Search engine PHP return error [closed]
  4. Auto Increment ID’s of 4 digit
  5. php nested while loop. Inner loop works only once [closed]
  6. Thank you for helping [closed]
  7. How can create Database using url or other method [duplicate]
  8. How to create email notification with login users on PHP an MySQL [duplicate]
  9. PHP display image BLOB from MySQL [duplicate]
  10. LIMIT keyword on MySQL with prepared statement [duplicate]
  11. Pagination using MySQL LIMIT, OFFSET
  12. How to call a MySQL stored procedure from within PHP code?
  13. Is mysql_real_escape_string() broken?
  14. How to setup ElasticSearch index structure with multiple entity bindings
  15. WAMP/MySQL errors not in correct language
  16. Get Updated Value in MySQL instead of affected rows
  17. Alternative for mysql_num_rows using PDO
  18. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  19. Can I blindly replace all mysql_ functions with mysqli_?
  20. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given [duplicate]
  21. Storing datetime as UTC in PHP/MySQL
  22. Using utf8mb4 with php and mysql
  23. how do I get month from date in mysql
  24. How do I save PHP session data to a database instead of in the file system?
  25. Strange problem with the length of the field gotten from database [duplicate]
  26. MySQL, how to insert null dates
  27. Can I detect and handle MySQL Warnings with PHP?
  28. Escaping SQL queries in Codeigniter
  29. How to write a stored procedure in phpMyAdmin?
  30. mysql count into PHP variable

Leave a Comment