-=BAHA=-, $sql = mysql_query('SELECT GROUP_CONCAT(`files`.`id` SEPARATOR ",") AS `ids_string` FROM `files`');
$str =mysql_fetch_row($sql);
$arr = explode(",", $str[0]);
$res = array();
while(sizeof($res) < 10) {
$key = $arr[array_rand($arr)];
$res[$key] = $key;
}
$sql2 = mysql_query("SELECT * FROM `files` WHERE `id` IN(" . implode(", ", $res) . ");
while($row = mysql_fetch_assoc($sql2)) {
echo '<pre>' . print_r($row, 1) . '</pre>';
}
как то так. с тела тяжело писать