Error found in theme installation

Hangin' Around Joined: Jul 15, 2008 Posts: 30

I have my theme I used with rn2.02, however when I try to use with my newly installed rn2.5 it is blank only the bg color.
When showing the error, it is Fatal error:
Call to a member function sql_query() on a non-object in /home/***/public_html/new/themes/Juma/theme.php on line 60

When I check theme.php on that line, I have
$toplist = $db->sql_query("select topicid, topictext from ".$prefix."_topics order by topictext");
while(list($topicid, $topics) = $db->sql_fetchrow($toplist)) {

What did I do wrong?

Site Admin Joined: Aug 22, 2007 Posts: 1772

Do you have added $db and $prefix as global?

Code:

function example() {


   global $db, $prefix;


   $toplist = $db->sql_query('SELECT `topicid`, `topictext` FROM `' . $prefix . '_topics` ORDER BY `topictext`');


   while(list($topicid, $topics) = $db->sql_fetchrow($toplist)) {


      // your code


   }


}

Posted: Sun Jan 06, 2013 3:45 am

Thank you so much Neralex.
Your suggestion works.
Thanks