How can i make a selection from a table random?

[Breana]

Ok, i want to make a sql statment select from a table, random quotes and display a random one each time the page is loaded!

I got it to connect, but it keeps selecting all of them...

[PHP]<?php
$sql = "select * from randomquotes where quote= $quote limit $quote,1";
$result = mysql_query($sql ,$db);
?>
Rando Quote: <? echo ("$quote"); ?>[/PHP]

So in the end it will load only one of the 500 table and be random each time selecting from any of them.
I hope i was clear on what i need.

[mwasif]

The following query will select randomly one record

select * from randomquotes ORDER BY RAND() LIMIT 1

[Breana]

How can i get it to load table randomquotes, table quote
and have it print it random?

It comes up blank.
[PHP]<?php
$sql = "SELECT * quote FROM randomquotes ORDER BY RAND() LIMIT 1";
$result = mysql_query($sql ,$db);
?>Rando Quote: <? echo ("$quote"); ?>[/PHP]

[Weisbartb]

You are missing a fetch function.
[PHP]<?php
$sql = "SELECT * quote FROM randomquotes ORDER BY RAND() LIMIT 1";
$result = mysql_query($sql ,$db);
$row = mysql_fetch_assoc($result);
?>
Random Quote:
<?
echo ($row['cellnameofquote']);
?>[/PHP]

[Breana]

Sweet thanx, i keep for getting about the fetch part lol.
SOLVED