$ mysqladmin create randomtips -p
$ mysql randomtips
$ randomtips>

-> CREATE TABLE randomtips (
->  id int(11) DEFAULT '0' NOT NULL auto_increment,
->  name varchar(50),
->  email varchar(100),
->  title varchar(200),
->  tipbody longtext,
->  PRIMARY KEY (id),
->  KEY randomtips_id (id),
-> );

$ randomtips> \q

Insert some data into your table...

$ mysql randomtips -p
$ randomtips> INSERT into randomtips VALUES('','authorname','email','tip
title',
-> 'tip body can be alot of text';
$ randomtips>\q

 
<?

$db_host = "localhost";
$db_user = "userid";
$db_passwd = "passwd";

$database = "dbname";


srand(time());
mysql_connect("localhost", "$db_user", "$db_passwd") or die("Unable to
connect to
database");
@mysql_select_db("$database") or die("Unable to select database");
$result = mysql_query("SELECT * FROM randomtips");

$numrows=mysql_num_rows($result);
$random=rand(0,$numrows-1);
mysql_data_seek($result,$random);
$tips=mysql_fetch_array($result);

// echo ($tips["t_stamp"]);
echo "<center><font size=+1 color=red>";
echo ($tips["title"]);
echo "</font></center>";
echo "<P>";
echo ($tips["tipbody"]);

?>

>> Comments/FeedBack