Hall of Fame

[sabor]

hello

can i get page list on my footer?
If i try copy page list code from sidebar to footer i see error:

"Fatal error: Call to a member function get_result() on a non-object in [...] on line 1450

This is code:

Code Select Expand

$pagesx = $db->get_results("select title,pid,pic from ".DB_PREFIX."pages WHERE menu = '1' ORDER BY title ASC ".this_limit()."");
 /* The pages lists */
 if($pagesx) {
echo '<div class="box"> 
<div class="box-head">
<h4 class="box-heading">'._lang('Information').'</h4>
</div>
	<div class="box-body list">	
	<ul>';
	foreach ($pagesx as $px) {
echo '<li><img src="'.thumb_fix($px->pic, true, 23, 23).'"><a href="'.page_url($px->pid, $px->title).'" title="'._html($px->title).'"> '._cut(_html($px->title),19).'</a></li>';

	
	}

  echo '  </ul>   
    </div>
    </div>';
}

[Marius]

Hi! I assume you need to define $db as global on the top of the function.

Code Select Expand

function footer_add(){
global $db, $cachedb;