Random load of all rows in a loop with no duplication in PHP

Question

I have a while loop that loads data from a table row into a div. After one row it loops and loads another row into a duplicate div and so on.

Now I want this loop to select rows at random but have exhausted all rows by the end without duplication.

I have rows:

I want (random order) rows:

basically load all rows but in random. I am using PHP.

May not even need to pop it off, just shuffle and loop on it once building the html during that one loop. — IncredibleHat
– IncredibleHat, Commented Feb 7, 2018 at 22:08

AbraCadaver · Accepted Answer · 2018-02-07 22:21:38Z

6

Probably easiest to ORDER BY RAND(). You don't show your DB API or functions so replace the function names with what you use:

$result = your_query('SELECT some1, some2 FROM table_name ORDER BY RAND()');

while($row = your_fetch($result)) {
    //use $row in div
}

If you already have your rows in an array, then:

shuffle($rows);

foreach($rows as $row) {
    //use $row in div
}

answered Feb 7, 2018 at 22:09

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1