wp pagination

pagination.php

// paging code
// Query to count rows.

$result = mysql_query("SELECT * FROM Table_Name WHERE Column_Name = '$section'")
$items = 32; // number of items per page.
$all = $_GET['a'];

$num_rows = mysql_num_rows($result);
  if($all == "all"){
  $items = $num_rows;
  }

$nrpage_amount = $num_rows/$items;
$page_amount = ceil($num_rows/$items);
$page_amount = $page_amount-1;
$page = mysql_real_escape_string($_GET['p']);
    if($page < "1"){
    $page = "0";
    }

$p_num = $items*$page;
//end paging code
// Query that you would like to SHOW
$result = mysql_query("SELECT * FROM Table_Name WHERE Column_Name = '$section' ORDER BY 'name' ASC LIMIT $p_num , $items");

function paging(){
  Global $num_rows;
  global $page;
  global $page_amount;
  global $section;

  if($page_amount != "0"){
  echo "<div class=paging>";

  if($page != "0"){
    $prev = $page-1;
    echo "<a href=\"section.php?q=$section&p=$prev\">Prev</a>";
  }
    for ( $counter = 0; $counter <= $page_amount; $counter += 1) {
      echo "<a href=\"section.php?q=$section&p=$counter\">";
      echo $counter+1;
      echo "</a>";
      }

        if($page < $page_amount){
        $next = $page+1;
        echo "<a href=\"section.php?q=$section&p=$next\">Next</a>";
        }

    echo "<a href=\"section.php?q=$section&a=all\">View All</a>";
    echo "</div>";
    }
} // close paging function

// call on Pagination with function
paging();