Bu Reklamı düzenle bölümü
<?php
include("db.php");
$sorgu=mysql_query("SELECT * FROM reklam");
while($v=mysql_fetch_array($sorgu)){
$id= $v['id'];
$q= $v['q'];
$p= $v['p'];
$d= $v['d'];
$y= $v['y'];
echo " <div align='center'>
<table border='0' cellpadding='0' cellspacing='0' width='67%' height='4' bordercolorlight='#D6D6D6' id='table1'>
<tr>
<td width='430'>reklamlar 1</td>
<td>
<p align='center'><a href='reklamlari.php?id=$id'>Düzenle</a></td>
</tr>
</table>
<div align='center'>
<table border='0' cellpadding='0' cellspacing='0' width='67%' height='59' bordercolorlight='#D6D6D6' id='table2'>
<tr>
<td height='21'>
<p align='center'>örnek</td>
</tr>
<tr>
<td>
<p align='center'>$q</td>
</tr>
</table>
</div>
</div>
";
}
?>düzenleye tıkladığı zaman gelen sayfa ise<?php
include("db.php");
$id = $_GET["id"];
$d = mysql_fetch_array(mysql_query("SELECT * FROM reklam WHERE id='$id'"));
$q = $d['1'];
$p = $d['y'];
$d = $d['y'];
$y = $d['y'];
echo "<form action='rguncelle.php' method='post'>
<div align='center'>
<table border='0' cellpadding='0' cellspacing='0' width='55%' height='366' bordercolorlight='#D6D6D6' id='table1'>
<tr>
<td align='center' height='170'><b><font size='7'>468*60</font></b></td>
<td align='center' height='170' width='9'><b><font size='7'>:</font></b></td>
<td align='center' valign='top' height='170' width='403'>
<p><textarea rows='8' name='q' cols='46'>$q</textarea></p>
<p> </td>
</tr>
<tr>
<td align='center'><font size='7'><b>728*90</b></font></td>
<td align='center' width='9'><font size='7'><b>:</b></font></td>
<td align='center' valign='top' width='403'>
<textarea rows='8' name='p' cols='46'>$p</textarea></td>
</tr>
<tr>
<td align='center'><font size='7'><b>300*250</b></font></td>
<td align='center' width='9'><font size='7'><b>:</b></font></td>
<td align='center' valign='top' width='403'>
<textarea rows='8' name='d' cols='46'>$d</textarea></td>
</tr>
<tr>
<td align='center' height='59'><font size='7'><b>160*600</b></font></td>
<td align='center' height='59' width='9'><font size='7'><b>:</b></font></td>
<td align='center' height='59' valign='top' width='403'>
<textarea rows='8' name='y' cols='46'>$y</textarea></td>
</tr>
</table>
<p><input type='submit' value='Güncelle' name='guncelle'></div>
</form>";
?>Burdada güncelleme butonuna bastığı zaman da <?php
include("db.php");
$id = $_POST['id'];
$q = $_POST['q'];
$p = $_POST['p'];
$d = $_POST['d'];
$y = $_POST['y'];
$guncelle = mysql_query("UPDATE reklam SET q='$q',p='$p',d='$d',y='$y' WHERE id='$id'");
if($guncelle){
echo "<center>Güncellendi</center>";
header("refresh: 0; url=basarili.php");
}else{
echo "<center>HATA ! <BR>Güncellenemedi</center>";
header("refresh: 2; url=hata.php");
}
?> güncellendi diye bana uyarı veriyor başarılı.php dosyasına gönderiyor ama mysql de ve sitede olduğu gibi duruyor yani güncellenemiyor.