Random results from Mysql

[Yahook]

There are two different ways to do it:

1) Using the query like this one:
$sql = "SELECT * FROM tablename
LIMIT $num1,$NUM_RESULTS";
where $num1 - random number from php script

2) Using the query like this one:
$sql = "SELECT * FROM tablename
ORDER BY RAND() LIMIT $NUM_RESULTS";

[xariton]

Thanks Yahook ;)
If you have a large database it's better to use first method.
"ORDER BY RAND()" - is not good to use with large database

[Yahook]

Thanks Yahook
If you have a large database it's better to use first method.
"ORDER BY RAND()" - is not good to use with large database

I agree with you but it's working only for one result. If you want to select more than one result you should make several queries to database - that's also not good.