Hey folks,

Just wondering if it's possible to select the latest 5 results from the database (based on product id), but order those 5 results randomally? - or would it require a mix of both PHP and MySQL?

Eg:

SELECT * FROM products ORDER BY pid ASC LIMIT 5 - and then make mysql randomise those 5 results picked?

Cheers!