Randomizing results from SQL with SQL

[gte806e]

Im trying to pull random elements out of a database for rotating ads in a sense. Im using this line of code in my sql query but it seems to ALWAYS pull the same elements out.

SELECT idNum, title
FROM listings
WHERE catagory = 'furniture'
ORDER BY RAND( )
LIMIT 3

Am i doing something wrong? Is there some other way to randomize this?

Thanks,

Jesse

[gte806e]

I've found a work around so nm =)

[tequilacat]

Would you mind sharing your work around? I'm having the same problem. When I use ORDER BY RAND() it seems to pull things in pretty much the same order.

Thanks!
Therese

[gte806e]

basically I seeded the MySQL rand() with a random number from the php random function. I found this in the forums. It works fine.

Jesse

[tequilacat]

Thanks Jesse, that works great!! I've got random results now.