Tablo yapını bu formata getirebilirsen,
CREATE TABLE `ayar` (
`id` tinyint(11) NOT NULL auto_increment,
`site_basligi` varchar(255) NOT NULL default '',
`okulun_adi` varchar(255) NOT NULL default '',
`ust_resim` varchar(255) NOT NULL default '',
`adres` varchar(255) NOT NULL default '',
`mail` varchar(255) NOT NULL default '',
`meta_kelime` varchar(255) NOT NULL default '',
`meta_aciklama` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin5 AUTO_INCREMENT=2 ;
Sorgularınıda aşağıdaki gibi yaparsan sorun kalmayacağini düşünüyorum
<?php
include ("yol.php");
switch ($_GET['mode']){
case ayarlarduzelt:
$sorgu = mysql_query("SELECT * FROM ayar WHERE id = '$_GET[id]'");
while ($bilgi = mysql_fetch_array($sorgu)){
?>
<form action="yonetim.php?mode=ayarlarduzelt&id=<?=$_GET['id']?>" method="POST" >
<table width="400" border="1" cellspacing="0" cellpadding="0">
<tr><td width="50"><font face="Verdana" size="2" color="Black">Site Basligi:</font></td>
<td width="260"><input type="Text" name="site_basligi" size="105" value="<?=$bilgi[site_basligi];?>"></td>
</tr>
<tr><td width="50"><font face="Verdana" size="2" color="Black">Okulun Adi:</font></td>
<td width="260"><input type="Text" name="okulun_adi" size="105" value="<?=$bilgi[okulun_adi];?>"></td>
</tr>
<tr><td width="50"><font face="Verdana" size="2" color="Black">Ust Resim:</font></td>
<td width="260"><input type="Text" name="ust_resim" value="<?=$bilgi[ust_resim];?>" size="55" cols="39"></td>
</tr>
<tr><td width="50"><font face="Verdana" size="2" color="Black">Adres:</font></td>
<td width="260"><input type="Text" name="adres" size="105" value="<?=$bilgi[adres];?>"></td>
</tr>
<tr><td width="50"><font face="Verdana" size="2" color="Black">Mail:</font></td>
<td width="260"><input type="Text" name="maill" size="105" value="<?=$bilgi[maill];?>"></td>
</tr>
<tr><td width="50"><font face="Verdana" size="2" color="Black">Meta kelime:</font></td>
<td width="260"><input type="Text" name="meta_kelime" size="105" value="<?=$bilgi[meta_kelime];?>"></td>
</tr>
<tr><td width="50"><font face="Verdana" size="2" color="Black">Meta Aciklama:</font></td>
<td width="260"><input type="Text" name="meta_aciklama" size="105" value="<?=$bilgi[meta_aciklama];?>"></td>
</tr>
<tr><td>
<input type="hidden" name="kaydet" value="1" />
<input type="hidden" name="id" value="<?=$bilgi['id'];?>" />
<input type="Submit" name="Send Mail" value="Gonder"> </td></tr>
</table></form><br>
<?
$id = $_POST['id'];
$site_basligi=$_POST['site_basligi'];
$okulun_adi=$_POST['okulun_adi'];
$ust_resim=$_POST['ust_resim'];
$adres=$_POST['adres'];
$maill=$_POST['maill'];
$meta_kelime=$_POST['meta_kelime'];
$meta_aciklama=$_POST['meta_aciklama'];
}
if ($kaydet == 1) {
$sorgu = mysql_query("UPDATE ayar SET
site_basligi='$site_basligi',
okulun_adi='$okulun_adi',
ust_resim='$ust_resim', adres='$adres',
maill='$maill', meta_kelime='$meta_kelime',
meta_açiklama='$meta_açiklama', WHERE
id='$id'");
echo "<script language='javascript'>alert('Düzenleme İşlemi Başarıyla Tamamlanmıştır...'); .href='yonetim.php?mode=ayarlar.php';</script>";
}
else {
echo "Hata oluştu";
}
break;
default:
?>
<center>
<?
$toplam_kayit = mysql_result(mysql_query("SELECT COUNT(*) AS toplam_kayit FROM ayar"),0,"toplam_kayit");
?>
<font face="Century Gothic" color="#51A8FF">Toplam Kayıt : </font><?=$say;?>
<a href="yonetim.php?mode=ayarlarekle"></center>
<table width="800" border="1" cellspacing="0" cellpadding="0" align="CENTER">
<tr>
<td colspan="9" align="CENTER" valign="MIDDLE">AYARLAR</td>
</tr>
<tr>
<td align="CENTER"><b>id<b></td>
<td align="CENTER"><b>Site Basligi<b></td>
<td align="CENTER"><b>Okulun Adi<b></td>
<td align="CENTER"><b>Ust Resim<b></td>
<td align="CENTER"><b>Adres<b></td>
<td align="CENTER"><b>Mail<b></td>
<td align="CENTER"><b>Meta Kelime<b></td>
<td align="CENTER"><b>Meta Aciklama<b></td>
<td align="CENTER"><b>Duzelt<b></td>
<td align="CENTER"><b>Sil<b></td>
</tr>
<?
$oku = mysql_query("SELECT * FROM ayar ORDER BY id DESC");
while ($okunan = mysql_fetch_array($oku)){
?>
<tr>
<td align="CENTER"><?$okunan['id']?> </td>
<td align="CENTER"><?$okunan['site_basligi']?> </td>
<td align="CENTER"><?$okunan['okulun_adi']?> </td>
<td align="CENTER"><?$okunan['ust_resim']?> </td>
<td align="CENTER"><?$okunan['adres']?> </td>
<td align="CENTER"><?$okunan['maill']?> </td>
<td align="CENTER"><?$okunan['meta_kelime']?> </td>
<td align="CENTER"><?$okunan['meta_aciklama']?> </td>
<td align="CENTER" bgcolor="#FFC891"><a href="yonetim.php?mode=ayarlarduzelt&id=<?$okunan['id']?>">Düzelt</a></td>
<td align="CENTER" bgcolor="#FF4A4A"><a href="yonetim.php?mode=ayarlarsil&id=<?$okunan['id']?>"> Sil </a></td>
</tr>
<?php
}
}
?> </table>