random record

[anorakgirl]

having a silly problem...

at the command prompt in mysql, if i type

select * from mytable order by rand() limit 1

i get a different record each time.

however, in my php page, i have the line

$myresult= mysql_query("SELECT * FROM mytable order by rand() limit 1");

and it seems to bring back the same record each time.

am i missing something? is there a better way to get a random record?

ta!

[laserlight]

hmm... maybe you have to seed it, i.e. use RAND(NOW()) instead of just rand() ?