Simple Random Array Selection

[influx]

Hey all,

I am simply aiming to do the following:

When somebody visits my page, I want to display a random selection of three phrases. I have a database of twelve phrases, and I want three of them to be randomly selected and displayed when somebody opens my webpage.

I would need an array to do this and would need to randomly select three of the twelve phrases. I just can't find the syntax online to do it.

Thank in advance for your help!
-influx

[TimTimTimma]

<?php

$count_them = mysql_num_rows("SELECT * FROM table");
$get_them = mysql_query("SELECT * FROM table WHERE id = ".rand(1, $count_them));
$quotes = mysql_fetch_array($get_them);

echo $quotes['quote_field'];
echo $quotes['quote_field'];
echo $quotes['quote_field'];

?>

That will allow you to show 3 random quotes and as you add quotes to the database it qill automatically pick them up and attempt to display them randomly. Of course this script works based on the assumption each quote has its own unique id starting at 1 and going up

[wilku]

A way to do it with only one query:

mysql_query("SELECT * FROM table ORDER BY RAND() LIMIT 0,3;"); 

and then a while loop to retrieve three rows.