Anyone had a problem with combining SELECT DISTINCT .... ORDER BY RAND() in a query using MySQL 3.23.x, where 'x' is later than 5? There's a reference on the MySQL site to fixing a bug involving the above in 3.23.5, but I'm seeing it in two later versions. To save the space of the disinterested :-) the gory details are at <http://webtuitive.com/samples/sql-prob.html> TIA! -- Hassan Schroeder ----------------------------- hassan at webtuitive.com Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code.