8.14. How do I do a random display of items?

(Answered by Bill Carr)

If you are using mysql (and others probably), you should be able to add "ORDER BY RAND()" to your SQL query. For example:

[query
   list=1
   sql=|SELECT * FROM products ORDER BY RAND() LIMIT 3|
]
[list]
        [sql-param description]<br>
[/list]
[/query]