How Do I Randomize The Reviews?

[DK_Scully]

I already looked at Random Product Reviews for SideBox, and that's not what I need. I only want 3 to show at a time, but I want them to be random, not in precisely the order they were entered. Is there a way to do this?

Thanks!!

[nigelt74]

You could try this
Turn on the reviews sidebox
set "Random Product Reviews for SideBox" to 3

Now its going to show them in order, which aint what you what

so go to

/includes/modules/sideboxes/reviews.php

and save it as
/includes/modules/sideboxes/yourtemplate/reviews.php

now open the file for editing

around line 25 it says

 and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'" .
$review_status;

Change it to

and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'" .
$review_status. " ORDER BY RAND()";

and see if that does what you want

[DK_Scully]

Perfect...thank you so much!!!!!