[eluser]PhilTem[/eluser]
I'm not sure if I got your question, right: Do you want to randomize the rows you retrieve from the database, or do you want to first get a set of data from the DB and then randomize this?
For the first case, you can of course use MySQL's RAND() but you may also create a set of 10 random integers serving as primary keys and only grab these. Getting that random primary keys array is rather simple with PHP
Of course you need to ensure, that the randomly generated keys are valid keys and that you don't have any keys twice or three times, but as just mentioned, it's rather simple.
The second one might be similar to the first one, i.e. you have your query result handle $query and then just use a random number
n (or 10) to retrieve the
n-th row of your results like
Code:
$row = $query->row($random_number); // for object
$row = $query->row_array($random_number); // for array
Maybe I'm not far off what you were aiming to get and hopefully it will lead you into the right direction.
PS: None of the ways mentioned above changes the type of data you get from the DB, i.e. it's still an array or an object, depending on how you want it.
