arkdaşlar bi hata daha var yardım olun lütfen
burda botla veriyi çekiyorum ve igbitti.php de kaydetmeye çalışıyorum
<?php
include("db.php");
$id = $_GET["id"];
$v = mysql_fetch_array(mysql_query("SELECT * FROM videolar WHERE id='$id'"));
$resim= $v['resim'];
$katid= $v['katid'];
echo "<form action='igbitti.php' method='POST'>
<div align='center'>
<table border='0' cellpadding='0' cellspacing='0' width='67%' height='40' bordercolorlight='#D6D6D6' id='table1'>
<tr>
<td height='19'>
<p align='right'><font color='#FF00FF'><b>Resim Url Si</b></font></td>
<td height='19' width='8' align='center'>:</td>
<td height='19' width='339'>
<input type='text' name='resim' size='54' value='$resim'></td>
</tr>
<tr>
<td>
<p align='right'><font color='#FF00FF'><b>Kategorisi</b></font></td>
<td width='8' align='center'>:</td>
<td width='339'><select name='katid'></form> ";
include("db.php");
$kategoriler=mysql_query("SELECT * FROM kategoriler");
while($a=mysql_fetch_array($kategoriler)){
$id=$a['id'];
$katbaslik=$a['katbaslik'];
echo "<option value='$id'>$katbaslik</option>";
echo "
?></select></td>
</tr>
</table>
<div align='center'>
<table border='0' cellpadding='0' cellspacing='0' width='67%' height='24' bordercolorlight='#D6D6D6' id='table2'>
<tr>
<td>
<p align='center'>
<input type='hidden' name='id' value='$id'>
<input type='submit' value='güncelle' name='guncelle'></td>
</tr>
</table>
</div>
</div>
</form></form>
";
}
?>burdada igbittti.php var ama kaydet diyorum olmuyor hata var diyor
<?php
include("db.php");
$id = $_POST['id'];
$resim = $_POST['resim'];
$katid = $_POST['katid'];
$guncelle = mysql_query("UPDATE videolar SET resim='$resim' katid='$katid' 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");
}
?>hata da ise şöyle bir hata diyor
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'katid='2' WHERE id='2'' at line 1
hadi nolur yardım edin