"; //echo "$bolums"; echo ""; echo ""; echo ""; /////////////////////////////////// Sayfalama ////////////////////////////////////////// $query = "SELECT COUNT(*) from member_info where member_fullname like '$harf%' order by active='1' desc"; $result = mysql_query($query) or die(mysql_error()); $num_rows = mysql_fetch_row($result); $db->items_total = $num_rows[0]; $db->mid_range = 10; $db->paginates(); /////////////////////////////////// Sayfalama ////////////////////////////////////////// if(strlen($harf)>0){ $members=$db->sqllistrow("select * from member_info where member_fullname like '$harf%' order by active='1' desc, member_fullname asc $db->limit"); }else{ $members=$db->sqllistrow("select * from member_info where active='1' order by member_fullname asc $db->limit"); } foreach($members as $key=>$value){ //$harfs=$db->sqllistrow("SELECT DISTINCT mid(member_fullname,1,1) as harf FROM member_info WHERE member_fullname='$value[member_fullname]' like convert(_utf8 '%' USING latin1) collate latin1_swedish_ci"); $hstr=$db->sqllistrow("SELECT DISTINCT mid(member_fullname,1,1) as harfx FROM member_info WHERE member_fullname like convert(_utf8 '%' USING latin1) collate latin1_swedish_ci order by member_fullname"); foreach($hstr as $key=>$valn){ $name = StrToBuyuk($value[member_fullname]); $job = StrToBuyuk($value[member_job]); $city = StrToBuyuk($value[member_city]); } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

Görsel	Adı Soyadı	İş/Meslek	Şehir
	$name	$job	$city

"; echo ""; echo "