EOM; //////////////////////////////////////// // for pagination $page = sanitize(1,4, $_GET['page']); if($page){$pageNR = $page;}else{$pageNR = 1;} $start = ($pageNR * $items_per_page) - $items_per_page; $navigator_query = mysql_query("SELECT * FROM user_group_list WHERE enabled = 'Y'"); $totalrows = mysql_numrows($navigator_query); // calculate out total number of pages $nr_pages = ceil(mysql_num_rows($navigator_query)/$items_per_page); $paginator = navigator(); //////////////////////////////////////// if($paginator != ''){$top_paginator = "$paginator

";} print << $totalrows members
(Sorted by $sort_by) $top_paginator   EOM; print ""; print ""; print ""; print ""; print ""; $userlist = "SELECT * FROM user_group_list WHERE enabled = 'Y' ORDER BY $ob $asc_dec LIMIT $start, $items_per_page"; //print $userlist; $userlist_result = mysql_query($userlist); if(mysql_num_rows($userlist_result) > 0){ while($user_row = mysql_fetch_array($userlist_result)){ $uid = $user_row['user_id']; $first_name = $user_row['first_name']; $last_name = $user_row['last_name']; $country = $user_row['country']; $country_code = $user_row['country_code']; $join_date = $user_row['join_date']; $per_text = $user_row['per_text']; $geo_area = $user_row['geo_area']; $allow_msg = $user_row['allow_msg']; $intro_text = $user_row['intro_text']; $member_image = $user_row['member_image']; $member_title = $user_row['member_title']; if($first_name == ''){$first_name = ' ';} if($last_name == ''){$last_name = ' ';} if($country == ''){$country = ' ';} if($per_text == ''){$per_text = ' ';} if($geo_area == ''){$geo_area = ' ';} if($member_title != ''){$member_title = "($member_title)";} if($country_code != ''){ $flag_img = ""; }else{ $flag_img = ""; } if($member_image == '' || $member_image == 'no'){ $member_pic = ""; }else{ $member_pic = ""; } if($intro_text == ''){ $intro_text = '(No introduction text yet)'; }else{ $intro_text = ""$intro_text""; } $member_timestamp = strtotime($join_date); $member_since = date("F j, Y", $member_timestamp); print << EOM; } }else{ print "No members found....."; } print '
 NameLocal AreaCountryMember Since
$member_pic $first_name $last_name
$member_title
$geo_area $flag_img $country $member_since
$intro_text

'; print "$paginator

"; print << EOM; // get footer include('/var/www/virtual/psoug.org/htdocs/footer.php'); ?>