Ayuda con Paginacion.

   <?
$num_total_registros0 = $core_db->Execute("SELECT count(Name) FROM Character");
$num_total_registros = $num_total_registros0->fields[0];
        
       
        //Si hay registros
        if ($num_total_registros > 0) {
        //Limito la busqueda
        $TAMANO_PAGINA =5;
        $pagina = false;
        //examino la pagina a mostrar y el inicio del registro a mostrar
        if (isset($_GET["pagina"]))
            $pagina = $_GET["pagina"];
        
    	if (!$pagina) {
        $inicio = 0;
        $pagina = 1;
    	}
    	else {
        $inicio = ($pagina -1) * $TAMANO_PAGINA;
    	}}
    	//calculo el total de paginas
    	$total_paginas = ceil($num_total_registros / $TAMANO_PAGINA);   
		   
$query=mssql_query("select  TOP 5 *  from Character Where ctlcode !='32' and ctlcode !='8'  order by ResetCount desc,Grand_Resets desc,cLevel desc");   
 //Fix Del Count
        if($_GET['pagina']=='1' or $_GET['pagina']==''){
            $count=0;
        }else{
            $count=5*($_GET['pagina']-1);
        }           
while($row=mssql_fetch_assoc($query)){
$cont++;
$namez=$row['Name'];
$llvlsz=$row['cLevel'];
$ResetCountz=$row['ResetCount'];
$GResetCountz=$row['Grand_Resets'];
$classz=$row['Class'];
$lasresetz=$row['LastReset'];
$PkCountz=$row['PkCount'];
$masterlevel = mssql_fetch_row(mssql_query("SELECT MasterLevel FROM MasterSkillTree WHERE Name='".$namez."'"));
$MLevel= $masterlevel[0];
require("Onlines/class.php");
$GensF=$row['GensType'];
require("Onlines/gens_small.php");
$accountpj=$row['AccountID'];
$PaispjInfo = mssql_fetch_row(mssql_query("SELECT country,memb___id FROM MEMB_INFO WHERE memb___id='".$accountpj."'"));
$PaisG2 = $PaispjInfo[0];


$guildxd =  mssql_fetch_row(mssql_query("SELECT G_Name FROM GuildMember WHERE Name='".$namez."'"));
$Guildok = $guildxd[0]; 
switch ($cont) {
    case 1:
        $_rankMedalTH= "top1.png";
        break;
    case 2:
        $_rankMedalTH= "top2.png";
        break;
    case 3:
        $_rankMedalTH= "top3.png";
        break;
            case 4:
        $_rankMedalTH= "4";
        break;
  
  }
    
   
$onlineoks = mssql_fetch_row(mssql_query("Select ConnectStat from memb_stat where memb___id='".$accountpj."'"));
$onok = $onlineoks[0];
require("Onlines/onlicheck.php");    



            echo'<table class="content_rank" width="95%">  <tr>';
               
              if ($cont<=3) {
                echo'<td width="30px"><img src="Images_Rank/'.$_rankMedalTH.'"> </td>';
             } else { 
                
                echo'<td class="namerkn" width="30px">'.$cont.'</td>'; }
				
               
               
              
                
                echo'<td class="namerkn" width="150px">'.$PaisG2.' <a  href="index.php?page_id=chararter&char='.$namez.'">'.$namez.'</a> '.$onok.'</td>
                <td class="fiximgs" width="50px">'.$classz.'</td>
                <td class="namerkn" width="50px">'.$llvlsz.'<small>'.$MLevel.'</small></td>
                <td class="namerkn" width="50px">'.$ResetCountz.'<small> '.$GResetCountz.'</small></td>
                 <td align="center" class="namerkn" width="50px"><a  href="index.php?page_id=guild&gid='.$Guildok.'">'.$Guildok.'</a></td>          
            </tr></table>';
            
   
 
   

}

/* CONTADOR DE PAGINAS */
    echo '<ul class="pagination">';
    if ($total_paginas > 1) {
        if ($pagina != 1)
            echo '<li><a href="'.$core_run_script.'&pagina='.($pagina-1).'">&laquo;</a></li>';
        for ($i=1;$i<=$total_paginas;$i++) {
            if ($pagina == $i)
                //si muestro el �ndice de la p�gina actual, no coloco enlace
                echo '<li class="active"><a>'.$pagina.'</a></li>';
            else
                //si el �ndice no corresponde con la p�gina mostrada actualmente,
                //coloco el enlace para ir a esa p�gina
                echo '<li><a href="'.$core_run_script.'&pagina='.$i.'">'.$i.'</a></li>';
        }
        if ($pagina != $total_paginas)
            echo '<li><a href="'.$core_run_script.'&pagina='.($pagina+1).'">&raquo;</a></li>';
    }
    echo '</ul>';
	echo''.$total_pagina.'';

?>

$page = 1;

$q = 'SELECT * FROM character LIMIT '. $page .',5';