Random Quote on ForumHome.

[vietfancy]

I created a table "quotes" in the database, and added a few quotes in there.

I want to pull it from the database and randomly post on forumhome, But it doesn't seem to work.. Please help...:(

Here is what I did . I created a plugin with hook location set to global_complete
// begin random quote on forumhome
$r_quote = $db->query_first('
SELECT author,quote FROM ' .
TABLE_PREFIX . 'quotes
ORDER BY RAND()
LIMIT 1
');
$randomquote = "<b>$r_quote[quote]</b>";
// end random quote on forumhome