Randomizing results within a LEFT JOIN

[jamesmu]

Does anyone know how can i change this statement so it doesnt just pick the most recent entry from tbl_folderimage but instead randomises the results and then groups by folder_id.

SELECT * FROM tbl_folderimage 
LEFT JOIN tbl_image ON tbl_folderimage.image_id = tbl_image.image_id 
LEFT JOIN tbl_folder ON tbl_folderimage.folder_id = tbl_folder.folder_id 
WHERE tbl_folder.folder_rate='5' 
AND tbl_folderimage.folderimage_rate='5' 
AND tbl_folder.folder_fix='1' 
GROUP BY tbl_folderimage.folder_id 
ORDER BY RAND();

Does that make sense?

Thanks

James

[y0h_azakura87]

$rand = rand(1,10);

switch($rand){
case 1:
$order = 'field1';
case 2:
$order = 'field2';
case 3:
$order = 'field3';
case 4:
$order = 'field4';
case 5:
$order = 'field5';
}

$sql = "SELECT * FROM table ORDER BY $order";

[y0h_azakura87]

i miss the breaks