[SOLVED] Selecting random entries.

[Michdd]

Is there a way to select random entries with a limit and some where clauses? I know I can do some things like.. put some clauses in an array and random get one (eg. ordering by something different each time) and selecting a random number to start as the lower-limit.. But is there a better way to do this?

[Maq]

Is there a way to select random entries with a limit and some where clauses? I know I can do some things like.. put some clauses in an array and random get one (eg. ordering by something different each time) and selecting a random number to start as the lower-limit.. But is there a better way to do this?

 

Sure, you can use pure MySQL to do this:

 

SELECT * FROM table ORDER BY RAND() LIMIT 10

 

This selects 10 random records from the table.

[Michdd]

Is there a way to select random entries with a limit and some where clauses? I know I can do some things like.. put some clauses in an array and random get one (eg. ordering by something different each time) and selecting a random number to start as the lower-limit.. But is there a better way to do this?

 

Sure, you can use pure MySQL to do this:

 

SELECT * FROM table ORDER BY RAND() LIMIT 10

 

This selects 10 random records from the table.

Sorry, this was kind of a waste of a topic.. I should've searched google. I didn't think it was that simple.. Anyway, thanks.

[Maq]

I wouldn't consider it a waste, but yeah, Google and a search of these forums could have gotten you the answer.  Now there's more for others to reference