Hi Payne, This is probably because of a bug in MySQL versions before 3.23.56 and 4.0.10 -- RAND() didn't work right the first time it was used in a *new* connection. After the first run, though, it was OK.
To work around the problem, I've told people to just call RAND() a few times before doing your query. Just like this in PHP: mysql_query('SELECT RAND(), RAND(), RAND()'); Then the ORDER BY RAND() query should be random. Now that I think about it, putting RAND() twice in the ORDER BY would probably have the same effect. So you could try $result = mysql_query('... ORDER BY RAND(), RAND() LIMIT 1'); Hope that helps. Matt ----- Original Message ----- From: "Payne" Sent: Tuesday, November 04, 2003 10:33 AM Subject: RAND () > Hi, > > I have been playing around with RAND(). It works very well if I do a sql > statement with mysql, but I having problem using with mysql statement > with php. When a person calls on the page, the same output is always > view. How can I get RAND() work with php. > > sorry for the php, stuff. Thanks for any help you can give. > > Payne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]