PHP MySQL pagination with random ordering

by

Use RAND(SEED). Quoting docs: “If a constant integer argument N is specified, it is used as the seed value.” (http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_rand).

In the example above the result order is rand, but it is always the same. You can just change the seed to get a new order.

SELECT * FROM your_table ORDER BY RAND(351);

You can change the seed every time the user hits the first results page and store it in the user session.

More Related Contents:

  1. Is the following code valid? [closed]
  2. Undefined index $_POST
  3. PHP Merging Row with same value (more than one column)
  4. How do I get the last inserted ID of a MySQL table in PHP?
  5. Getting raw SQL query string from PDO prepared statements
  6. How to get count of rows in MySQL table using PHP?
  7. “Invalid parameter number: parameter was not defined” Inserting data
  8. MySQL Prepared statements with a variable size variable list
  9. Fatal error: Call to undefined function mysql_connect()
  10. Having issue with matching rows in the database using PDO
  11. PHP & MySQL: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given [duplicate]
  12. How can I properly use a PDO object for a parameterized SELECT query
  13. How can I enable the MySQLi extension in PHP 7?
  14. MySQL server has gone away – in exactly 60 seconds
  15. Why is password_verify returning false?
  16. Doctrine Query Language get Max/Latest Row Per Group
  17. Laravel OrderBy relationship count
  18. Dynamic table in HTML using MySQL and php
  19. How can I decrypt a password hash in PHP?
  20. Is mysql_real_escape_string() necessary when using prepared statements?
  21. Updating from MYSQL to MYSQLI [duplicate]
  22. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  23. Creating dynamic tables in HTML using MySQL and PHP
  24. PHP to MySQL SSL Connections
  25. PHP Laravel: No connection could be made because the target machine actively refused it
  26. Create PHP array from MySQL column
  27. UNION syntax in Cakephp
  28. How do I format numbers to have only two decimal places?
  29. Group mysql results by category and display them into groups under each category
  30. PHP & mySQL: When exactly to use htmlentities?

Leave a Comment