[AlienSector]

Before making this post, I searched around and came across the following code (modified to fit my data) and I am not exactly sure where to place it to make it function as it needs to.

Coding Snippet: https://vborg.vbsupport.ru/showthrea...ght=pagination

$rescount= $DB_site->query_first("SELECT COUNT(*) AS id FROM resources WHERE isstuck='no'"); 
            $perpage= 6; 
            if(empty($page)) 
            { 
                $page= 1; 
            } 
            $start= (($page * $perpage) - $perpage); 
            $pagenavigation = construct_page_nav($rescount[id], "resources.php?", "pp=$perpage");

I am trying to make it so that the data I am pulling from the database below is paginated accordingly, though it does not seem to be working as it should be (or as I had thought). While the limit function above does work and show only 6 of the 7 entries, no links are presented on the page for me to get to the next.

$getresources = $DB_site->query("SELECT * FROM resources WHERE type='vbulletin' AND isstuck='no' ORDER BY id DESC LIMIT $start,$perpage");
	while($resource = $DB_site->fetch_array($getresources))
	{

		eval('$resources .= "' . fetch_template('index_resourcedata') . '";');

	}

eval('print_output("' . fetch_template('index_resourcedisplay') . '");');

Any help is appreciated as I would like to get this working as soon as possible .