Ben bir üyelik sistemi yaptım bu üye bilgi güncelleme olayınıda yapıyorum ama sorgu çalışmıyor ben bir hata göremedim kodlarda ama neden çalışmıyor hata alıyorum acaba ?
<?
include "baglan.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9">
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-family: Arial, Helvetica, sans-serif;
}
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
#panel {
background-repeat: no-repeat;
font-family: Arial, Helvetica, sans-serif;
}
#panel .panelust {
background-repeat: no-repeat;
background-image: url(images/uyepaneli/uyeust.png);
height: 55px;
}
#panel #panelic {
background-repeat: no-repeat;
height: 400px;
}
#panel a:link {
color: #000066;
text-decoration: none;
font-weight: normal;
}
#panel a:hover {
color: #3E89D7;
text-decoration: underline;
}
#panel a:active {
color: #000081;
text-decoration: none;
}
#panel a:visited {
color: #000081;
text-decoration: none;
}
.style2 {color: #C78717}
.style11 {
font-size: 15px;
font-weight: bold;
}
-->
</style>
</head>
<?
if ( isset($_GET["uyeno"]) ) {
$uyeno = $_GET["uyeno"];
//önce ürün grubunu yokla
$sorgu = "SELECT * FROM uyeler WHERE uno = '$uyeno'";
//echo $sorgu;
$sorgula = mysql_query($sorgu) or die("Sorgu çalışmadı. (39)");
$kaysay = mysql_num_rows($sorgula);
if ($kaysay == 0) { //grup zaten kayıtlı ise
die("Lütfen adres satırındaki verilere müdahele etmeyiniz. Bu dosyayı doğrudan çağırmayınız!.");
}
//$gno = mysql_result($sorgula, 0, "gno");
$sifre = mysql_result($sorgula, 0, "sifre");
$adsoy = mysql_result($sorgula, 0, "adsoy");
$tel = mysql_result($sorgula, 0, "tel");
$adres = mysql_result($sorgula, 0, "adres");
$eposta = mysql_result($sorgula, 0, "eposta");
$dtarih = mysql_result($sorgula, 0, "dtarih");
$cins = mysql_result($sorgula, 0, "cins");
}
//güncelle düğmesine basıldıysa
if ( isset($_POST["guncelle"]) ) {
$uyeno = $_POST["uyeno"];
$sifre = $_POST["sifre"];
$adsoy = $_POST["adsoy"];
$tel = $_POST["tel"];
$adres = $_POST["adres"];
$eposta = $_POST["eposta"];
$dtarih = $_POST["dtarih"];
$cins = $_POST["cins"];
}
$sorgu = "UPDATE uyeler ";
$sorgu .= "SET
sifre = '$sifre',
adsoy = '$adsoy',
tel = '$tel',
adres = '$adres',
eposta = '$eposta',
dtarih = '$dtarih',
cins = '$cins'
WHERE uyeno = $uyeno";
//die($sorgu);
$sorgula = mysql_query($sorgu) or die("Sorgu çalışmadı! (84)");
echo"$uno numaralı ürün bilgileri güncellendi.";
?>
<body>
<form
action="<? echo $_SERVER['PHP_SELF']; //Kendine yolla ?>" method="post" enctype="multipart/form-data" name="fmkayit" onSubmit="return kontrol()">
<table width="834" height="380" border="0" cellpadding="0" cellspacing="0" id="panel">
<tr>
<td height="47" colspan="2" valign="top"><div class="panelust">
<table width="757" border="0" cellpadding="6">
<tr>
<td width="539" valign="top">?php echo'<b>Hoşgeldiniz Sayın, <font color="#FF0000">'.$uyeadsoy.'</font></b>'; ?></td>
<td width="263"><a href="urunler.php"><img src="http://forum.ceviz.net/images/uyepaneli/uincele.png" alt="" width="213" height="34" border="0" /></a></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td width="823" valign="top"><div id="panelic">
<table width="84%" height="165" border="0" cellpadding="10" cellspacing="2">
<tr>
<td width="35%" bgcolor="#FFFFCC"><strong>Şifre Değiştir:
<label></label>
</strong></td>
<td width="45%"><input name="sifre" type="password" id="sifre" value="<? echo $sifre; ?>" /></td>
<td width="5%"> </td>
<td width="15%"> </td>
</tr>
<tr>
<td height="42" bgcolor="#FFFFCC"><strong>Adınız ve Soyadınız: </strong></td>
<td><input name="eposta" type="text" id="eposta" value="<? echo $adsoy; ?>" /></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="42" bgcolor="#FFFFCC"><strong>E-Posta Adresiniz:</strong></td>
<td><input name="eposta" type="text" id="eposta" value="<? echo $eposta ?>" /></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="39" bgcolor="#FFFFCC"><strong>Adresiniz:</strong></td>
<td><textarea name="adres" cols="45" rows="10" id="adres"><? echo $adres; ?></textarea></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="39" bgcolor="#FFFFCC"><span class="style11">Doğum Tarihiniz:</span></td>
<td><select name="gun" id="gun">
<? for($g = 01 ; $g < 32 ; $g++) {?>
<option value=" <?=$g ?>">
<?=$g ?>
</option>
<? } ?>
</select>
<select name="ay" id="ay">
<? for($a = 01 ; $a < 13 ; $a++) {?>
<option value="<?=$a ?>">
<?=$a ?>
</option>
<? } ?>
</select>
<select name="yil" id="yil">
<? for($y = 1940 ; $y < 2011 ; $y++) {?>
<option value="<?=$y ?>">
<?=$y ?>
</option>
<? } ?>
</select></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="39" bgcolor="#FFFFCC"><strong>Cinsiyetiniz:</strong></td>
<td><select name="cins" id="cins">
<option value="ERKEK" selected="selected">Erkek</option>
<option value="BAYAN">Bayan</option>
</select></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="39"> </td>
<td align="right">
<input style="font-family: Tahoma; font-size: 8pt; color: #FFFFFF; font-weight: bold; border: 1px solid #000000; height:40; width:100; background-color: #ff8400" type="submit" name="kaydet" id="kaydet" value="Kaydet" /> </td>
<td colspan="2"><a href="cikis.php">Güvenli Çıkış</a> </td>
</tr>
</table>
</div></td>
<td width="1"> </td>
</tr>
<tr>
<td valign="top"> </td>
<td> </td>
</tr>
<tr>
<td valign="top"> </td>
<td> </td>
</tr>
<tr>
<td valign="top"> </td>
<td> </td>
</tr>
</table>
</form>
</body>
</html>