'; $sort_phone=''; $sort_address=''; if ($sort == NULL || $sort == 'name'){$sort ="name";$sort_name='';} if ($sort == 'phone'){$sort_phone='';} if ($sort == 'address'){$sort_address='';} //Limit $num_sup=0; $num_total=0; $limit=@$_GET['limit']; if ($limit == Null){$limit=0;} $start=$limit; $end=25; mysql_select_db($database_connection, $connection); $query = "SELECT * FROM `vendors` order by `".$sort."` ASC"; $query_limit=$query." LIMIT $start, $end"; $result_limit = mysql_query($query_limit) or die("Couldn't execute Limit query"); $result = mysql_query($query) or die("Couldn't execute Total query"); while ($set_row = mysql_fetch_array($result)){ $num_total=$num_total+ 1;} echo'

'; while ($set_row = mysql_fetch_array($result_limit)){ $num_sup=$num_sup + 1; $customer_id =$set_row['id']; $customer_person =$set_row['contact_person']; $customer_name =$set_row['name']; $customer_address =$set_row['address']; $customer_city =$set_row['city']; $customer_zipcode =$set_row['zipcode']; $customer_phone =$set_row['phone']; $customer_mobile =$set_row['mobile']; $customer_fax =$set_row['fax']; $customer_email =$set_row['email']; $customer_info =$set_row['info']; echo' ';} echo'
'.$sort_name.'Location '.$sort_phone.'Phone No. '.$sort_address.'Address  

'.$customer_name.'

'.$customer_phone.'

'.$customer_address.'

'; if ($_SESSION['GPMA_type'] == 1){ echo' Delete    ||     Edit'; } echo'

'; $next=$limit+$num_sup; if ($next < $num_total ){echo '
Next

';} $pre=$limit-25; if ($start > 0 ){echo ' Prevouse

';} ?>