Paging

[assgar]

Hello
I have a search page where you select the letter of the alphabet
and the person's information who's name beginning with that letter is displayed.
This function is placed on the web page to search and display the information.
Everything works except one thing.
The problem is if there are 3 pages page one is OK, but when you select next to go to page two the information on page two is no displaying.
Can you see something I missed or have any suggestion?
[php]
<?php
function search_display($org_code, $field, $searching, $find, $let, $stat_type, $contact_field)
{

//db connection and selection
$mysqli = db_connect();
db_select($mysqli, $org_code);

/**-----------------------pagination begins ------------------------**/
//how many rows to show per page
$rowsPerPage = 11;

// by default we show first page
$pageNum = 1;

//if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}

//counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;



//alphabet listing search except all
if(!empty($let) && $let !== "All" )
{
$query = "SELECT p.patient_id, p.last_name, p.first_name, p.id,
c.contact_number
FROM pat p, contact c
WHERE p.id = c.id
AND $field LIKE '$let%'
AND p.pat_status = '$stat_type'
AND p.org_code = '$org_code'
AND p.org_code = c.org_code
AND c.$contact_field = '$contact'
AND p.deleted = 'N'
ORDER BY p.last_name, p.first_name
";
}

//table begins
echo "\n";


//------------------------------looping----------------------------------
$num_service = mysqli_num_rows($result);
for($i=0; $i < $num_service; $i++)
{
$row = mysqli_fetch_array($result);

list($id, $last_name, $first_name, $id, $contact_number) = $row;


//zebra stripping
if($i % 2) //alternate row colour
{
$bgcolor="#eeeee0";
}
else
{
$bgcolor="#ebeae0";
}
echo"
$last_name

$first_name
$id$contact_number\n";
echo"\n";

}//end of for loop

/**----------------pagination continue-------------------**/
echo '
';

//how many rows we have in database
$result = mysqli_query($mysqli,$query) or die('Error, query failed');
$numrows = mysqli_num_rows($result);

//how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);

$self = $_SERVER['PHP_SELF'];

/** creating 'previous' and 'next' link plus 'first page' and 'last page' link
print 'previous' link only if not on page one **/

if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = "[Prev] ";
$first = "[First Page] ";
}
else
{
$prev = '[Prev]'; /* we're on page one, don't enable 'previous'
link*/
$first = '[First Page]'; // nor 'first page' link
}

//print 'next' link only if we're not
//on the last page
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = "[Next]";
$last = "[Last Page]";
}
else
{
$next = '[Next]'; /* we're on the last page, don't
enable 'next' link*/
$last = '[Last Page]'; // nor 'last page' link
}

// print the page navigation link
echo" ". $first . $prev . " $pageNum of
$maxPage pages " . $next . $last."";

$mysqli->close();

}
?>
[/php]

[assgar]

I forgot this bit of code that is found under the select.
[php]
$pagingQuery = "LIMIT $offset, $rowsPerPage";
$result = mysqli_query($mysqli,$query.$pagingQuery) or die('Error, query failed');
[/php]

[assgar]

I forgot this bit of code that is found under the select. [php] $pagingQuery = "LIMIT $offset, $rowsPerPage"; $result = mysqli_query($mysqli,$query.$pagingQuery) or die('Error, query failed'); [/php]

Thanks for the suggestions.

I have resolved the problem.
Using the next and other navigation links to pass variables via the URL that is used to retrive data from the database like the "ID" was required.