$maxlength) return substr($str, 0, $maxlength)." ..."; else return $str; } $content=""; $result = db_query("SELECT count(*) from {$CONFIG['TABLE_PICTURES']} WHERE aid=11", $dbi); $nbEnr = mysql_fetch_array($result); $count = $nbEnr[0]; while ($stop<$numberpic) { srand(time()+$stop); $random_number = rand(0, $count-1); $result2 = db_query("SELECT pid, aid, filepath, filename from {$CONFIG['TABLE_PICTURES']} WHERE aid=11 AND approved='YES' LIMIT $random_number,1", $dbi); // aid numbers can be changed as need to respect permissions $picture = mysql_fetch_array($result2); $img = ""; $content .= "$img


"; $stop++; } $content .= ""; print $content; ?>