random value from db

[ovisopa]

Hello ppl,
I want to make a script which can extract from a db a random id from a table.
The table from the db is like this:

+----+---------+------+--------+-----+-------+----------+----+
| id | contest | name | adress | tel | email | comments | ip |
+----+---------+------+--------+-----+-------+----------+----+

I have on my site some contests, the ppl just need to complete a form and to answer to a question to win 🙂.
In "contest" column will be inserted the contest type, I will have 3 different values ther, for evry contest one value:
+---------+
| contest |
+---------+
| RDS |
+---------+
| milion |
+---------+
| modem |
+---------+

What I need is a script to extract a random id from the db and from a single contest type.

Any help is aprecieted, 10x

see ya

[planetsim]

Ok this works for one row but you can change that if you want

$result=mysql_query("SELECT * FROM tbl_name ORDER BY RAND() LIMIT 1");