Select Random Record

[alsaffar]

Hi there,

I want to select one record randomly, how can I acheive my goal?

Please help.

 

[DRJ478]

When you are saying "record", what do you mean?

If you meand a record from a database query:
1. issue the query and get the resource identifier
2. ascertain the number of records in the set.
3. use the rand() function to get a random number between 0 and the number of records -1

http://www.php.net/manual/en/function.rand.php

4. in MySQL e.g. use mysql_data_seek() to point to the random record.
5. get the data, example: mysql_fetch_array() or similar command.

 

[sleipnir214]

If you're using MySQL, you can perform the query:

SELECT * FROM theTable ORDER BY rand() LIMIT 1

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!