Get random rows from a database

Thu Feb 05, 2015 2:00 am

I would like to recall 5 random and unique rows from a database.

I have my database, its connected, am getting results from a 'where', but would like to display on a page 5 random results.

Thu Feb 05, 2015 4:53 am

Hi Brett,

You can not do it with single request.

So only way - is to create server code. That's will fetch elements from the collection and shuffle them and return needed array.

Then you can use this server code in your app.

Regards.