Displaying data randomly

Anon

I have a database with some records let's say 5 records i like to display one of the record in my page randomly or rotate from all records.

can anyone help me?

Anon

just get the number of rows in the database, generate a random number between 0 and the number of rows, and then select from the database using limit

ralba1998

June - this should help ya

http://www.weberdev.com/get_example.php3?count=249

ralba1998

You can also put your results into a separate array - then just use the rand fucntion..

here is some code ---
$sayings = array("saying one", "saying two", "saying three");
srand(time());
$i = rand(0,count($sayings));
echo $sayings[$i];

I wish they made this box a bit wider --

I could do some more test. I hope this helps ya. I am ok at coding..

Anon

<?php
srand((double)microtime()*1000000);
$randstring = "";
for ($i=0;$i<1;$i++) {
$randstring = $randstring.rand(0,4);
}
if ($randstring == "0") {$picture = "URL HERE"; }
elseif ($randstring == "1") {$picture = "URL HERE"; }
elseif ($randstring == "2") {$picture = "URL HERE"; }
elseif ($randstring == "3") {$picture = "URL HERE"; }
elseif ($randstring == "4") {$picture = "URL HERE"; }
?>

I use it for changing the background...