I have code for sorting my problem now is on my paging because when I sort my data for example my data sorted to desc and when I click the next hyperlink the data was sort as asc which is wrong it should be still desc.
here is my code
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Untitled Document</title>
</head>
<body>
<form name="machine1" action="page3.php" method="post">
<?php
$sort = "ASC";
$data_sort = "Emp_ID";
if(isset($_GET['sorting']))
{
if($_GET['sorting'] == 'ASC'){
$sort = "DESC";
}
else{
$sort = "ASC";
}
}
if(isset($_GET['field_name']) == 'Emp_ID'){
$data_sort = "Emp_ID";
}
elseif(isset($_GET['field_name']) == 'Last_Name'){
$data_sort = "Last_Name";
}
elseif(isset($_GET['field_name']) == 'First_Name'){
$data_sort = "First_Name";
}
?>
<table border="1">
<tr>
<td><a href="page3.php?sorting=<?php echo $sort; ?>&field_name=Emp_ID">Emp ID</a></td>
<td><a href="page3.php?sorting=<?php echo $sort; ?>&field_name=Last_Name">Last Name</a></td>
<td><a href="page3.php?sorting=<?php echo $sort; ?>&field_name=First_Name">First Name</a></td>
<td><a href="page3.php?sorting=<?php echo $sort; ?>&field_name=Birthday">Birthday</a></td>
<td>Option</td>
</tr>
<?php
$host = 'localhost';
$user = 'root';
$db = "db_machine1";
mysql_connect("$host", "$user") or die(mysql_error());
mysql_select_db("$db") or die(mysql_error());
if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 1;
} // if
//$emp_id = $_POST['Emp_ID'];
//$query = "SELECT count(*) FROM table WHERE ...";
$query = "SELECT count(*) FROM tbl_machine1";
$result = mysql_query($query) or trigger_error("SQL", E_USER_ERROR);
$query_data = mysql_fetch_row($result);
$numrows = $query_data[0];
$rows_per_page = 5;
$lastpage = ceil($numrows/$rows_per_page);
$pageno = (int)$pageno;
if ($pageno > $lastpage) {
$pageno = $lastpage;
} // if
if ($pageno < 1) {
$pageno = 1;
} // if
$limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;
$query = "SELECT * FROM tbl_machine1 ORDER BY $data_sort $sort $limit";
$result = mysql_query($query) or trigger_error("SQL", E_USER_ERROR);
//... process contents of $result ...
while($info = mysql_fetch_array( $result ))
{
$emp_id = $info['Emp_ID'];
$lname = $info['Last_Name'];
$fname = $info['First_Name'];
$bday = $info['Birthday'];
$date = date('d-m-Y', strtotime($bday));
?>
<tr>
<td><?php echo $emp_id;?> </td>
<td><?php echo $lname;?> </td>
<td><?php echo $fname;?> </td>
<td><?php echo $date;?> </td>
<td><a href = 'edit.php?id=<?php echo $emp_id; ?>'>Edit</a> <a href='delete.php?id=<?php echo $emp_id; ?>' onClick="return confirm('Are you sure you want to delete?')">Delete</a></td>
</tr>
<?php
}
?>
</table>
<A HREF="javascript:void(0)" onClick="window.open('add.php','welcome','width=300,height=200')">
<input type="button" name="add" value="ADD"> </A>
<?php
if(isset($_GET['sorting']))
{
if($_GET['sorting'] == 'ASC'){
$sort = "ASC";
}
else{
$sort = "DESC";
}
}
if ($pageno == 1) {
echo " FIRST PREV ";
} else {
//echo " <a href='{$_SERVER['PHP_SELF']}?pageno=1'>FIRST</a> ";
//echo " <a href='{$_SERVER['PHP_SELF']}?pageno=1'>FIRST</a> ";
?>
<a href="page3.php?pageno=1<?php if(isset($_GET['field_name'])) { ?> $data_sort <?php echo $data_sort; } ?> <?php if(isset($_GET['sorting'])) { ?> $sort=<?php echo $sort; } ?>">FIRST</a>
<?php
$prevpage = $pageno-1;
// echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$prevpage'>PREV</a> ";
?>
<a href="page3.php?pageno=<?php echo $prevpage; ?><?php if(isset($_GET['field_name'])) { ?> $data_sort <?php echo $data_sort; } ?> <?php if(isset($_GET['sorting'])) { ?> $sort=<?php echo $sort; } ?>">PREV</a>
<?php
} // if
echo " ( Page $pageno of $lastpage ) ";
if ($pageno == $lastpage) {
echo " NEXT LAST ";
} else {
$nextpage = $pageno+1;
// echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$nextpage'>NEXT</a> ";
// echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$lastpage'>LAST</a> ";
?>
<a href="page3.php?pageno=<?php echo $nextpage; ?><?php if(isset($_GET['field_name'])) { ?> $data_sort <?php echo $data_sort; } ?> <?php if(isset($_GET['sorting'])) { ?> $sort=<?php echo $sort; } ?>">NEXT</a>
<a href="page3.php?pageno=<?php echo $lastpage; ?><?php if(isset($_GET['field_name'])) { ?> $data_sort <?php echo $data_sort; } ?> <?php if(isset($_GET['sorting'])) { ?> $sort=<?php echo $sort; } ?>">LAST</a>
<?php
}
// if
/*mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("db_machine1") or die(mysql_error());
$data_p = mysql_query("SELECT * FROM tbl_machine1") or die(mysql_error());
while($info = mysql_fetch_array( $data_p ))
{
$emp_id = $info['Emp_ID'];
$lname = $info['Last_Name'];
$fname = $info['First_Name'];
$bday = $info['Birthday'];
?>
<tr>
<td><?php echo $emp_id;?> </td>
<td><?php echo $lname;?> </td>
<td><?php echo $fname;?> </td>
<td><?php echo $bday;?> </td>
<td><a href = 'edit.php?id=<?php echo $emp_id; ?>'>Edit</a> <a href='delete.php?id=<?php echo $emp_id; ?>' onClick='confirmDelete();'>Delete</a></td>
</tr>
<?php
}*/
?>
</body>
</html>