arkadaş mysql dan çekilen verileri nasıl harfe göre sıralayabilirim
mysql dan
[IMG]file:///C:/DOCUME%7E1/BILGIS%7E1/LOCALS%7E1/Temp/moz-screenshot.jpg[/IMG][IMG]file:///C:/DOCUME%7E1/BILGIS%7E1/LOCALS%7E1/Temp/moz-screenshot-1.jpg[/IMG][IMG]file:///C:/DOCUME%7E1/BILGIS%7E1/LOCALS%7E1/Temp/moz-screenshot-2.jpg[/IMG][IMG]file:///C:/DOCUME%7E1/BILGIS%7E1/LOCALS%7E1/Temp/moz-screenshot-3.jpg[/IMG]<?php
db_baglanti();
$sorgu = mysql_query("SELECT kat_id, kat_baslik FROM kategoriler ORDER BY kat_id");
while($yaz = mysql_fetch_array($sorgu)) {
$turkce=array("ş","Ş","ı","(",")","'","ü","Ü","ö","Ö","ç","Ç"," ","/","*","?","ş","Ş","ı","ğ","Ğ","İ","ö","Ö","Ç","ç","ü","Ü");
$duzgun=array("s","S","i","","","","u","U","o","O","c","C","-","-","-","","s","S","i","g","G","I","o","O","C","c","u","U");
$baslik = str_replace($turkce,$duzgun,$yaz['kat_baslik']);
$baslik = preg_replace("@[^A-Za-z0-9\-_]+@i","",$baslik);
echo '<a href="katgoster.php?kat_id='. $yaz['kat_id'] .'&'. $baslik .'.html"> ' . ' ' . '<font size="5">' . '' . $yaz['kat_baslik'] . '<br></font></a>';
}
?>bu şekilde veri çekiyorumbunları nasıl harfe göre sırayabilirim.
ilgilenen herkeze tşklerr