$tablo=""; //Bozuk olan tr karakterlerin oldugu tablo adi $alan=""; //Bozuk olan tr karakterlerin oldugu alan adi $id_alan =""; //Tabloda primary key olan alanýn adý veya id no lar olan alanýn ismi mysql_connect("localhost","kullanýcý adý","sifre"); //db kullanýcý adý ifre mysql_select_db("db adý"); //db adý $kayitlar = mysql_query("select * from $tablo"); while($kayit = mysql_fetch_array($kayitlar)) { $yazi = $kayit[$alan]; $ara = array ('ı','Å?','ü','ç','ö','Ä?','ÅŸ','Ç','İ','ÄŸ','Åz','Ö','Ü','ı','Å?','ç','ö','Ä?','ÅŸ','Ç','İ','ÄŸ','Åz','Ö','Ü','ü','ÄŸ'); $degis = array ('ý','þ','ü','ç','ö','ð','þ','Ç','i','ð','Þ','Ö','Ü','ý', 'þ', 'ç', 'ö', 'ð', 'þ', 'Ç', 'i', 'ð', 'Þ', 'Ö', 'Ü', 'ü', 'ð'); $yeni = str_replace($ara, $degis, $yazi); $islem="update $tablo set $alan='".$yeni."' where $id_alan='".$kayit[$id_alan]."'"; $guncelle = mysql_query ( $islem ); } echo"Bitti"; ?>