Random text genrator

[GoldenMerc]

Hey,

Im wanting a system where it gives a random quote every 2 mins I need it to be able to use with a panel, so i think it would have to add the the database then pick up from the database in the page?
Ross

[L?KE]

<?php

include("config.php"); // your database connection, change as necessary.

$amount = mysql_num_rows(mysql_query("SELECT * FROM `quotes`"));
$rand = rand(1,$amount);

$query = mysql_query("SELECT * FROM `quotes` LIMIT $rand, 1;");
$fetch = mysql_fetch_array($query);

echo( $fetch['quote'] );
echo("<meta http-equiv='refresh' content='120;url=".$_SERVER['PHP_SELF']."'>");

?>

I'm hoping that works. Obviously change table names, db connections etc as necessary.