PHP Pagination

<?
include_once("headerfile.php");
if($_GET['process']=='edit_career'){
$sql_select_career="SELECT * FROM careers_jobs WHERE id=".$_GET['id'];
$sql_select_career_execute=mysql_query($sql_select_career);
$sql_select_career_results=mysql_fetch_assoc($sql_select_career_execute);

$jobtitle=$sql_select_career_results["jobs_title"];
$min_exp=$sql_select_career_results["jobs_minimum_experience"];
$max_exp=$sql_select_career_results["jobs_max_experience"];
$shortdescription=$sql_select_career_results["jobs_short_description"];
$longdescription=$sql_select_career_results["jobs_long_description"];
$active=$sql_select_career_results["jobs_active"];
$jobexpires=$sql_select_career_results["jobs_expires"];
}
?>
<script language="javascript">
function validateCareersFrm(){
if(document.getElementById("txt_careertitle").value==""){
alert("Please input Job Title.");
return false;
document.getElementById("txt_careertitle").focus();
}
if(document.getElementById("txt_careershortdescription").value==""){
alert("Please input Short Description.");
return false;
document.getElementById("txt_careershortdescription").focus();
}
if(document.getElementById("txt_careerdescription").value==""){
alert("Please input Long Description.");
return false;
document.getElementById("txt_careerdescription").focus();
}
if(document.getElementById("txt_dateexpires").value==""){
alert("Please input Job Expire Date.");
return false;
document.getElementById("txt_dateexpires").focus();
}
}
</script>

<tr>
<td width="100%" height="145">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="tbl_body">

<tr>
<td width="60%">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td width="21%"> </td>
<td width="79%"><img src="images/controlpannel.gif" border="0"/></td>
</tr>
<tr>
<td width="21%"> </td>
<td width="79%" valign="top">
<?
include_once("menu_buttons.php");
?>
</td>
</tr>
</table>
</td>
<td width="40%"> </td>
</tr>
<tr>
<td width="60%">

<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="tbl_content">
<tr>
<td width="100%">
<!-- <div class="tabber"> -->



<div class="tabber">
<div class="tabbertab">
<h2>View</h2>
<p>
<table border="1" bordercolor="#C0C0C0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="98%" id="tbl_updateusers">
<tr>
<td width="100%" background="images/td-form-header_background.gif" class="displayCaption"> View Careers</td>
</tr>
<tr>
<td width="100%">
<table cellpadding="0" cellspacing="0" style="border-collapse: collapse" border="0" width="100%">
<?
$sql_jobs_list="SELECT * FROM careers_jobs";
$sql_jobs_list_execute=mysql_query($sql_jobs_list);
$job_list_rows=mysql_num_rows($sql_jobs_list_execute);
if($job_list_rows==0){
echo "There are no current records in the database.";
}else{
$page=$_GET["page"];
if($page == "") $page=1;
$next_page=$page+1;
$limit = 10;
$no_of_pages = ceil($job_list_rows/$limit);

$pageurl=explode('/', $_SERVER['REQUEST_URI']);

$thispage=$pageurl[4];
$pageurl_var=explode('?', $thispage);
$thispage_var=$pageurl_var[0];
//echo $thispage."<br>".$thispage_var;
if(($thispage_var=="careers.php") && ($no_of_pages>1) && ($next_page<=$no_of_pages) && (!$_GET['process'])){
//echo "hello";
echo "<script>setTimeout(\"window.location='careers.php?page=".$next_page."'\",10000);</script>";
}
$slno=$_GET["slno"];
/*
if($slno=="") $slno=0;
echo $slno;
$slno=$slno+1;
*/
$slno=1;
unset($sql_jobs_list);
unset($sql_jobs_list_execute);

$sql_max_record="SELECT MAX(id) max_id, MIN(id) min_id FROM careers_jobs";
$sql_max_record_execute=mysql_query($sql_max_record);
$max_id_results=mysql_fetch_array($sql_max_record_execute);
$max_id=$max_id_results[0];
$min_id=$max_id_results[1];

$sql_jobs_list="SELECT * FROM careers_jobs ORDER BY id LIMIT ".($page-1)*$limit." , $limit";
//echo $sql_users_list;
$sql_jobs_list_execute=mysql_query($sql_jobs_list) or die(mysql_error());
while($job_list_results=mysql_fetch_array($sql_jobs_list_execute)){
?>
<tr>
<td class="dataDisplay" width="10%"><?=$slno;?></td>
<td class="dataDisplay" width="46%"><a href="careers.php?process=edit_career&id=<?=$job_list_results["id"];?>"><?=$job_list_results["jobs_title"];?></a></td>
<td class="dataDisplay" width="2%"><?if($job_list_results["id"]!=$min_id){?><a href="dataprocess.php?process=moveup_career&id=<?=$job_list_results["id"];?>"><img src="images/move_up.jpg" border="0" alt="Move Up" title="Move Up"><?}?></a></td>
<td class="dataDisplay" width="2%"><?if($job_list_results["id"]!=$max_id){?><a href="dataprocess.php?process=movedown_career&id=<?=$job_list_results["id"];?>"><img src="images/move_down.jpg" border="0" alt="Move Down" title="Move Down"/><?}?></a></td>
<td align="center" class="dataDisplay" width="40%"><a href="dataprocess.php?process=delete_career&id=<?=$job_list_results["id"];?>"><img src="images/delete.gif" border="0" onClick="return confirmDelete();"/></a></td>
</tr>
<?
$slno++;
}
}
?>
</table>
</td>
</tr>
<tr>
<td width="100%" background="images/td-form-header_background.gif" class="displayPagination"> 
<?
$nav="";
if($page > 1) {
$nav .= "<A href=\"careers.php?page=" . ($page-1) . "\"><< Previous</A>";
}
for($i = 1 ; $i <= $no_of_pages ; $i++) {
if($i == $page) {
$nav .= " $i ";
}else{
$nav .= "<A href=\"careers.php?page=" . $i . "\">$i</A>";
}
}
if($page < $no_of_pages) {
$nav .= "<A href=\"careers.php?page=" . ($page+1) . "\">Next >></A>";
$nav .="";
}
echo $nav;
?>
</td>
</tr>
</table>
</p>
</div>


<div class="tabbertab">



<h2>Add</h2>
<P>

<form name="frm_addcareers" method="post" action="dataprocess.php">
<table border="1" bordercolor="#C0C0C0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="98%" id="tbl_updateusers">
<tr>
<td width="100%" background="images/td-form-header_background.gif" class="displayCaption"> Add / Update Careers</td>
</tr>
<tr>
<td width="90%" align="center" bgcolor="#ffffff">
<?

$process=$_GET['process'];
if(!$_GET['process']){
$process="add_career";
}
?>
</td>
</tr>
<tr>
<td>
<table id="tbl_login" width="100%" cellpadding="2" cellspacing="2" border="0">
<tr>
<td colspan="2">
<div class="formFieldDisplay" id="js_submission_error" style="visibility:hidden;display:none">
</div>
</td>
</tr>
<tr>
<td align="right" valign="top" class="formFieldDisplay">Job Title:</td><td><input type="text" name= "txt_careertitle" id="txt_careertitle" size="20" value="<?=$jobtitle;?>"></td>
</tr>
<tr>
<td align="right" valign="top" class="formFieldDisplay">Min Experience:</td>
<td><select size="1" name="cmb_min_exp">
<?
for($i=0;$i<=20; $i++){
?>
<option value="<?=$i;?>" <?if($min_exp==$i){ echo "SELECTED"; }?>><?=$i;?></option>
?>
<?}?>
</select>
</td>
</tr>
<tr>
<td align="right" valign="top" class="formFieldDisplay">Max Experience:</td>
<td><select size="1" name="cmb_max_exp">
<?
for($i=0;$i<=20; $i++){
?>
<option value="<?=$i;?>" <?if($max_exp==$i){ echo "SELECTED"; }?>><?=$i;?></option>
?>
<?}?>
</select>
</td>
</tr>
<tr>
<td align="right" valign="top" class="formFieldDisplay">Short Description:</td><td><textarea id="txt_careershortdescription" rows="6" name="txt_careershortdescription" cols="100"><?=$shortdescription?></textarea></td>
</tr>
<tr>
<td align="right" valign="top" class="formFieldDisplay">Long Description:</td><td><textarea rows="20" id="txt_careerdescription" name="txt_careerdescription" cols="100"><?=$longdescription?></textarea></td>
</tr>
<tr>
<td align="right" valign="top" class="formFieldDisplay">Visible:</td><td class="formFieldDisplay">
<?
if($process=="add_career"){
?>
<input type="radio" name="rdo_active" Value="1" Checked>
<?}else{?>
<input type="radio" name="rdo_active" Value="1" <?if($active=='1'){ echo "Checked"; }?>>
<?}?>
Active <input type="radio" name="rdo_active" Value="0" <?if($active=='0'){ echo "Checked"; }?>> Inactive
</td>
</tr>
<tr>
<td align="right" valign="top" class="formFieldDisplay">Date Expires:</td><td><input type="text" id="txt_dateexpires" name="txt_dateexpires" size="9" readonly VALUE="<?=$jobexpires;?>"><a href="javascript:cal9.popup();"><img src="img/cal.gif" width="16" height="16" border="0" alt="Click Here to Pick up the date"></a></td>
</tr>
<tr>
<td> <input type="hidden" value="<?=$process;?>" name="process"><input type="hidden" value="<?=$_GET["id"];?>" name="id"></td><td><input type="submit" value="Add Job" onclick="javascript:return validateCareersFrm();"></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<script language="JavaScript">
var cal9 = new calendar3(document.forms['frm_addcareers'].elements['txt_dateexpires']);
cal9.year_scroll = true;
cal9.time_comp = false;
</script>
</p>
</div>





<!--
<div class="tabbertab">
<h2>Update</h2>
<p>Tab 3 content.</p>
</div> -->
<!-- </div> -->


</td>
</tr>
</table>

</td>
<td width="40%"> </td>
</tr>
</table>
</td>
</tr>


<?
include_once("footer.php");
?>