Display in random order

[Blatch]

I have a db of items with `id`s. And I'm currently displaying them with a loop in DESC order (5, 4, 3, 2, 1).

PHP Code:

$query = mysql_query("SELECT * FROM `table` ORDER BY `id` DESC");
while($row = mysql_fetch_array($query)) {
    echo 'This is item number' . $row["id"] . '<br />';
} 


How can I modify this so it will display like this instead:

This is item number 3
This is item number 1
This is item number 2
This is item number 4
This is item number 5

Randomly. Thanks!

[SKDevelopment]

PHP Code:

$query = mysql_query("SELECT * FROM `table` ORDER BY RAND()");
while($row = mysql_fetch_array($query)) {
    echo 'This is item number' . $row["id"] . '<br />';
} 


[Mwnciau]

PHP Code:

$ids = array();

$query = mysql_query("SELECT * FROM `table` ORDER BY `id` DESC");
while($row = mysql_fetch_array($query))
    $ids[] = $row['id'];

shuffle($ids);

foreach ( $ids as $id )
    echo 'This is item number' . $id . '<br />';
} 


[Blatch]

Thank you both!