$query= "select * from users where bloodgroup like '%$bloodgroup%' or state like '%$state%' "; //$query = "SELECT COUNT(*) as num $from_where"; $total_pages = mysql_fetch_array(mysql_query($query)); $total_pages = $total_pages['num']; $extra = (isset($extra))? $extra : ""; /* Setup vars for query. */ $page = (isset($_REQUEST['page']))? $_REQUEST['page'] : 1 ; if($page) $start = ($page - 1) * $limit; //first item to display on this page else $start = 0; //if no page var is given, set start to 0 /* Get data. */ //$sql = "SELECT $column_name $from_where LIMIT $start, $limit"; //$result = mysql_query($sql); /* Setup page vars for display. */ if ($page == 0) $page = 1; //if no page var is given, default to 1. $prev = $page - 1; //previous page is page - 1 $next = $page + 1; //next page is page + 1 $lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up. $lpm1 = $lastpage - 1; //last page minus 1 $pagination = ""; if($lastpage > 1) { $pagination .= "