> Try seeding your rand. Tried. It doesn't work. The select shows always the same records but in different order:
SELECT * FROM banners GROUP BY user_id ORDER BY RAND(); first call +----+---------+---------------+ | id | user_id | title | +----+---------+---------------+ | 1 | 1 | first banner | | 3 | 2 | third banner | +----+---------+---------------+ second call +----+---------+---------------+ | id | user_id | title | +----+---------+---------------+ | 3 | 2 | third banner | | 1 | 1 | first banner | +----+---------+---------------+ etc... Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]