I have 3 variables that I generated from a query that I want to display on the FORUMHOME template, right under the guest welcome box. I keep trying but it's not working.
I have the PHP code to be executed at forumhome_start:
PHP Code:
$quote_sql = "SELECT id,author,text FROM " . TABLE_PREFIX . "quote ORDER BY rand() LIMIT 1";
$quote_result = $db->fetch_array($quote_sql);
$quote_sys_author = $quote_result['author'];
$quote_sys_text = $quote_result['text'];
$quote_sys_id = $quote_result['id'];
But when I try and print out "$quote_sys_id" or "$quote_sys_text," it returns blank. Any help?