PHP MySQL sort order ASC/DESC for only the records shown -

PHP MySQL sort order ASC/DESC for only the records shown -

i have query returns close 1000 records. using pagination, i'm showing 100 records per page. great...no problem. can sort lastly name or first name in either ascending of descending order. ok far. first page returns records lastly name starting c. problem i'm having when click lastly name descend records lastly name starting z. records @ end of query, want results going c (what shown on first page...repeating same functionality in each page.

here got...

$ordercolumn = 'lastname'; $orderdirection = 'asc'; if( isset($_post["oc"]) && $_post["oc"] !== '' ) { $ordercolumn = $_post["oc"]; } if( isset($_post["od"]) && $_post["od"] !== '' ) { $orderdirection = $_post["od"]; } $per_page = 100; $query = "select * table t left bring together table_2 t2 on t.pk_uid = t2.fk_uid left bring together table_3 t3 on t3.fk_utid = t2.pk_utid t3.fk_utid = 7 , t.interviewed = 0"; $result = $db->query($query); $count = mysql_num_rows($result); $total = ceil($count/$per_page); if ($_get['page']) { $page = $_get['page']; } $offset = (($page-1)*$per_page); $query2 = "select firstname first, lastname lastly table left bring together table_2 t2 on t.pk_uid = t2.fk_uid left bring together table_3 t3 on t3.fk_utid = t2.pk_utid t3.fk_utid = 7 , interviewed = 0 order $ordercolumn $orderdirection limit $offset, $per_page"; $res = $db-> query($query2); while($row = mysql_fetch_array($res)){ echo "<span style='display: inline-block; width: 15%;'>$row[first]</span>"; echo "<span style='display: inline-block; width: 15%;'>$row[last]</span>"; }

to saying in comment.. btw i'm on mobile phone may unformatted , or take while...

select what_you_need ( select your_inner_select table t left bring together table_2 t2 on t.pk_uid = t2.fk_uid left bring together table_3 t3 on t3.fk_utid = t2.pk_utid t3.fk_utid = 7 , interviewed = 0 limit $offset, $per_page order $ordercolumn asc )t order $ordercolumn $orderdirection

php mysql sorting