Call Random Row from a Database

I have a script where I am calling from a random row but it is only displaying selections from the first couple hundred rows. Here is the text:

Any Ideas?

Is there a better way to do this?

 

This will give you a single random row from $table:

<?php

$result = mysql_query('select * from ' . $table . ' order by rand() limit 1');

?>

PHP:

If you need more than a single random row, change limit 1 to however many random rows you want.

 

That even loads faster. Don't know where I came up with that complicated script I had.

Green to you

 

Glad to help