array_rand() problem

[Lazandra]

Hi guys

I'm trying to display one database entry randomly. So i have used array_rand(). However i have completely confused myself, and close to hitting my monitor with a tree branch.

This is my code

[PHP]srand((float) microtime() * 10000000);
$regs = mysql("db220854136","select * from listings");
while ($reg = mysql_fetch_array($regs))

{
$rand_keys = array_rand($reg, 2);
echo $rand_keys[4] - $rand_keys[1]. "\n";
}[/PHP]

But it doesn't display the actual variables i have asked it to, its displaying random numbers.... aaaagggggg!!!!

Any assistance would be greatly appreciated.

Laz
xx

[Lazandra]

i sorted it... when a completley different way...

[PHP]mySQL_Select_DB("db220854136");
$randoms = MySQL_Query("SELECT * FROM listings");
MySQL_Close($link);

$random_array = '';
$i = 0;
while ($entry = MySQL_Fetch_Array($randoms))
{
$random_array[$i] = $entry;
$i++;
}

$random_id = array_rand($random_array);
$random1 = $random_array[$random_id][address];
$random2 = $random_array[$random_id][description];

echo "$random1";
echo "$random2";[/PHP]

Cheers :-)

[coffear]

if you only require 1 record from the database why not just select 1 record from the database?

Use sort by RAND() LIMIT 1 at the end of your query and it will return 1 record randomly as a result.