hi it is working a bit.....
<html>
<head>
<title>Implementing Paging with next and prev</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
$industype=$_REQUEST['industype'];
$careerlevel=$_REQUEST['careerlevel'];
// how many rows to show per page
$rowsPerPage = 1;
// 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;
// $query = "SELECT val FROM randoms LIMIT $offset, $rowsPerPage";
// $result = mysql_query($query) or die('Error, query failed');
$hostname = "localhost";
$username = "";
$password = "";
$dbid = "";
$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid) or die("unable to connect");
$query="(select * from post_resume where ind_type='$industype' and career='$careerlevel' LIMIT $offset, $rowsPerPage)";
$result = mysql_query($query) or die ('Error in query: $query. ' . mysql_error());
echo "<table>";
if (mysql_num_rows($result) > 0)
{
$i=0;
while($row = mysql_fetch_row($result))
{
echo "<tr>";
echo "<td><a href='viewsearchres.php?id=".$row[0]."'>".$row[2]."</a></td></tr>";
echo "<tr><TD>Job Type</td><td> </td><td>".$row[4]."</td></tr>";
echo "<tr><TD>Highest Degree</td><td> </td><td>".$row[5]."</td></tr>";
echo "<tr><TD>Owner</td><td> </td><td>".$row[8]."</td></tr>";
echo "<tr><td bgcolor='#008080'></td><td bgcolor='#008080'></td></tr>";
$i++;
}
echo $i;
echo "</table>";
}
// print the random numbers
while(list($val) = mysql_fetch_array($result))
{
echo "$val <br>";
}
echo '<br>';
// how many rows we have in database
// $query = "SELECT COUNT(val) AS numrows FROM post_resume";
// $result = mysql_query($query) or die('Error, query failed');
// $row = mysql_fetch_array($result, MYSQL_ASSOC);
// $numrows = $row['numrows'];
$numrows = $i;
// 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 we're not on page one
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <a href=\"$self?page=$page\">[Prev]</a> ";
$first = " <a href=\"$self?page=1\">[First Page]</a> ";
}
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 = " <a href=\"$self?page=$page\">[Next]</a> ";
$last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
}
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 . " Showing page <strong>$pageNum</strong> of <strong>$maxPage</strong> pages " . $next . $last;
mysql_close($link);
?>
</body>
</html>
LIMIT will fetch only the number of records specified.i want to fetch all the matching records.
Output
Job Type Accounting/Auditing
Highest Degree Student(High Level)
Owner lydia
-----------------------------------------
1
[First Page] [Prev] Showing page 1 of 1 pages [Next] [Last Page]
the pages at the bottom are not working
Offline 
Marked 
