Random text from MySql table?

Anon

I'm not sure if this is the right place to post this, but here's what I need to find:

I have a MySql db set up with a table that I have data in. I want to pull a random entry from one of the columns. So let's say I ahev 30 rows, each with 4 fields. I want to generate a random result from one of the columns, so that 1 of the 30 is shown on some page somehwere.

Any ideas on how to do this, or where to find a little script that already does this?

Thanks!

Anon

Okay, I found out the command to get what I want, but I would like to be able to run this in a web page, and not in the actual Admin tool....

SELECT movie,notlisted FROM 2002may ORDER BY RAND() LIMIT 0, 1

Can I just throw this in a php file? I'm thinking there's a bit more to it.

Can anyone shed some light on it for me?

Anon

Connect to the DB server
$db = mysql_connect("localhost", "mysql_un", "mysql_pw");

Select the DB
mysql_select_db("table_name", $db);

Execute the query
$result = mysql_query ("SELECT movie,notlisted FROM 2002may ORDER BY RAND() LIMIT 0, 1");

Then deal with your returned rows however you want.