CodingForums.com - View Single Post - Random function limited to the first 10 ID's of db, must take 10 random from entireDB

Old Pedant · 01-15-2013, 09:27 PM

Ummm...well yeah, that's what your query asked for.

Code:

ORDER BY emailed_value desc, rating_value DESC limit 0, $display_nr";

Apparently, you want the more "important" jokes (by emailed_value, whatever that is, and then by rating_value). If you truly want random jokes, than you need to abandon the use of those "importance" qualifiers.

So just change it to

Code:

ORDER BY RAND() LIMIT 10

And then you will not need or want that ugly generate_random_array( ) function. The records *WILL* be in random order, already.

01-15-2013, 09:27 PM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,556 Thanks: 62 Thanked 4,055 Times in 4,024 Posts	Ummm...well yeah, that's what your query asked for. Code: ORDER BY emailed_value desc, rating_value DESC limit 0, $display_nr"; Apparently, you want the more "important" jokes (by emailed_value, whatever that is, and then by rating_value). If you truly want random jokes, than you need to abandon the use of those "importance" qualifiers. So just change it to Code: ORDER BY RAND() LIMIT 10 And then you will not need or want that ugly `generate_random_array( )` function. The records WILL be in random order, already. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.