Random table..

[GLIMPSE-MEDIA]

I need a little peice of code that will first cout how many entries there are in a table so it can set the range of numbers that it will randomly pick from.. then it will pick a random number.. it will then check to see if the entry exists (since it may have been deleted).. and if it does then spit that number out as a variable.. like $num. If it doesn't then it will do the process over again until it picks a random num that exists in the table. Can some one help out.

[HalfaBee]

What kind of table ?

If you mean an array then try this

echo $table[ rand(0,count($table))-1];

More info needed I think.
HalfaBee

[GLIMPSE-MEDIA]

Well, have a table in a database. There are entries in it. I want it to randomly select an entry. But, there may be some deleted entries. So that means that the numbers may not be conseutive. So if I have 1,2,3,4,5,6 entries, but delete 2, it will obviously be 1,3,4,5,6. So, I need to make sure that it doesn't randomly select 2.. because it isn't there. So after it counts the number of entries on in the table to set the range of numbers it will randomly pick from.. and after it picks a number in that range.. it then needs to check to see if it exists. If it doesn't then it needs to the process over again until it randomly finds a number that exists.

[HalfaBee]

$result=mysql_query( $sql  );
if( $result !== FALSE )
{
 if( ($rows=mysql_num_rows($result))!=0 )
   if(  $mysql_data_seek( $result , rand(0,$rows-1) ) )
     $rand_row = $mysql_fetch_array( $result );
}

The $rand_row should always be vaild.

Halfabee