How do I randomize the related gallery images?

[shuban]

Take this topic, for instance - http://biology-forums.com/index.php?topic=139886

Notice on the right it shows the related images. I'm sure there are a lot more related images, but it only shows the top three. What can I do to the following code to randomize them?

Code: [Select]

function Gallery_AddRelatedPicture($pictureID, $title = '')
{
global $db_prefix;

if (empty($title))
return;

db_query("INSERT IGNORE INTO {$db_prefix}gallery_title_cache
(ID_PICTURE, title)
VALUES ($pictureID, '$title')", __FILE__, __LINE__);


$relatedPics = Gallery_FindRelated($title, true);

if (empty($relatedPics))
return false;


$relatedPics = array_slice($relatedPics, 0, 10);

$picsSQL = '';

foreach ($relatedPics as $id)
if ($pictureID != $id[0])
$picsSQL .= '
(' . min($pictureID, $id[0]) . ', ' . max($pictureID, $id[0]) . ', ' . $id[1] . '),';

if (empty($picsSQL))
return false;

db_query("INSERT IGNORE INTO {$db_prefix}gallery_related_pictures
(id_picture_first, id_picture_second, score)
VALUES" . substr($picsSQL, 0, -1), __FILE__, __LINE__);

}

function Gallery_FindRelated($title, $score = false)
{
global $db_prefix;

$result = db_query("SELECT ID_PICTURE, MATCH(title) AGAINST('$title') AS score
FROM {$db_prefix}gallery_title_cache
WHERE MATCH(title) AGAINST('$title')
ORDER BY MATCH(title) AGAINST('$title') DESC", __FILE__, __LINE__);

$data = array();

while ($row = mysql_fetch_assoc($result))
{
if ($score == false)
$data[] = $row['ID_PICTURE'];
else
$data[] = array($row['ID_PICTURE'], $row['score']);
}

return $data;
}

[SMFHacks]

It would probably be this part of code
$relatedPics = array_slice($relatedPics, 0, 10);

You would need before it randomize the $relatedPics array

[shuban]

It would probably be this part of code
$relatedPics = array_slice($relatedPics, 0, 10);

You would need before it randomize the $relatedPics array

I thought I'd need to use RAND somewhere...

[SMFHacks]

In the mysql query normally use order by rand
but for php data array you can use shuffle command http://php.net/manual/en/function.shuffle.php

[shuban]

I tried this, but it didn't work.

Code: [Select]

$relatedPics = shuffle($relatedPics);

$relatedPics = array_slice($relatedPics, 0, 10);
   $picsSQL = '';

[shuban]

Wait this worked:

Code: [Select]

shuffle($relatedPics);

[shuban]

You should have a mark as solved button on here.