abone şifresiyle giriş yaptığı zaman, yönetim panelinde;
ilk önce kendi üyelik bilgileri geliyor.. Sonra abone olduğu dergiler varsa sıralamak istemiştim..
satırında hata alıyorum..$yazsemerkand = mysql_fetch_array($okusemerkand);
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
Yardımcı olursanız sevinirim.
tablo yapısı
CREATE TABLE `kullanici` (
`kullanici_id` int(11) unsigned NOT NULL auto_increment,
`kullanici_adi` char(25) NOT NULL default '',
`sifre` char(40) NOT NULL,
`eposta` char(100) NOT NULL default '',
`adi` char(25) NOT NULL default '',
`soyadi` char(25) NOT NULL default '',
`dogumtarihi` date NOT NULL default '0000-00-00',
`seviye` mediumint(1) NOT NULL default '4',
`bolge` varchar(255) NOT NULL,
`alt_bolge` varchar(55) NOT NULL,
`aktiflik` enum('0','1') NOT NULL default '0',
CREATE TABLE `semerkand` (
`semerkand_id` tinyint(11) NOT NULL auto_increment,
`kulanici_id` tinyint(11) NOT NULL,
`abone_yapan` varchar(19) NOT NULL,
`baslama` date NOT NULL,
`bitis` date NOT NULL,
`tutar` int(9) NOT NULL default '0',
`odenen` int(9) NOT NULL default '0',
CREATE TABLE `aile` (
`aile_id` tinyint(11) NOT NULL auto_increment,
`kulanici_id` tinyint(11) NOT NULL,
`abone_yapan` varchar(19) NOT NULL,
`baslama` date NOT NULL,
`bitis` date NOT NULL,
`tutar` int(9) NOT NULL default '0',
`odenen` int(9) NOT NULL default '0',
CREATE TABLE `mostar` (
`mostar_id` tinyint(11) NOT NULL auto_increment,
`kulanici_id` tinyint(11) NOT NULL,
`abone_yapan` varchar(19) NOT NULL,
`baslama` date NOT NULL,
`bitis` date NOT NULL,
`tutar` int(9) NOT NULL default '0',
`odenen` int(9) NOT NULL default '0',
$kullanici_adi = $_SESSION['kullanici_adi'];
$oku = mysql_query("SELECT * FROM kullanici where kullanici_adi= '$kullanici_adi' ");
$yaz = mysql_fetch_array($oku);
?>
<tr>
<td><?=$yaz['kullanici_id'];?></td>
<td><?=$yaz['adi'];?></td>
<td><?=$yaz['soyadi'];?></td>
<td><?=$yaz['eposta'];?></td>
<td><?=$yaz['adres1'];?></td>
<td><?=$yaz['tel'];?></td>
<td><?=$yaz['ceptel'];?></td>
<td><?=$yaz['bolge'];?></td>
<td><?=$yaz['alt_bolge'];?></td>
</tr>
</table>
<?
$gelenid = $yaz['kullanici_id'];
//echo $gelenid; echo "<br>";
$okusemerkand = mysql_query("select * from semerkand where kullanici_id= '$gelenid' ");
$yazsemerkand = mysql_fetch_array($okusemerkand);
?>
<table border="1" cellspacing="0" cellpadding="0" align="CENTER">
<tr>
<td> </td>
<td><font face="Lucida Sans" size="+1" color="#0080FF">Abone baslangic</font></td>
<td><font face="Lucida Sans" size="+1" color="#0080FF">Abone bitis</font></td>
<td><font face="Lucida Sans" size="+1" color="#0080FF">Tutar</font></td>
<td><font face="Lucida Sans" size="+1" color="#0080FF">Odenen</font></td>
<td><font face="Lucida Sans" size="+1" color="#0080FF">Kalan</font></td>
<td><font face="Lucida Sans" size="+1" color="#0080FF">Abone Yapan</font></td>
</tr>
<tr>
<td><img src="../images/semerkand_buton.gif" width=80 height=20 border=0 alt=""></td>
<td><?=$yazsemerkand['baslama'];?></td>
<td><?=$yazsemerkand['bitis'];?></td>
<td><?=$yazsemerkand['tutar'];?></td>
<td><?=$yazsemerkand['odenen'];?></td>
<td><?=$yazsemerkand['kalan'];?></td>
<td><?=$yazsemerkand['abone_yapan'];?></td>
</tr> 