LoverzSoft adlı üyeden alıntı:
mesajı görüntüle
mysql num rows hatası
11
●1.635
- 20-07-2009, 16:52:50Üyeliği durduruldu
<? if ($silanam == "tumunusil") { $sorgu = "DELETE FROM privmsg WHERE kime = '$verified_user' "; mysql_query($sorgu); } if ($ok) { foreach($id as $kayit) { $sorgu = "DELETE FROM privmsg WHERE kime = '$verified_user' and id = '$kayit' LIMIT 1"; mysql_query($sorgu); } } $sorgu = "select id,konu,gonderen,gun,okundu,ay,yil,saat from privmsg WHERE kime = '$verified_user' ORDER BY tarih desc"; $sorgulama = mysql_query($sorgu); if (mysql_num_rows($sorgulama)>0){ //kayıtları listele echo " <form name=mailOperations method=post action=> <table width=\"597\" border=\"0\"> <tr> <td colspan=\"4\">Gelen Mesajlar </td> </tr> <tr> <td width=\"29\"><div align=\"center\"></div></td> <td width=\"101\"><strong>gönderen</strong></td> <td width=\"321\"><div align=\"center\"><strong>konu</strong></div></td> <td width=\"134\"><div align=\"center\"><strong>tarih</strong></div></td> </tr> <tr> <td colspan=\"4\" align=\"center\" valign=\"bottom\"><table width=\"597\" border=\"1\" cellpadding=\"0\" cellspacing=\"1\" bordercolor=\"#00000\"> "; while ($kayit=mysql_fetch_array($sorgulama)){ $id=$kayit["id"]; $gonderen=$kayit["gonderen"]; $konu=$kayit["konu"]; $gun=$kayit["gun"]; $ay=$kayit["ay"]; $yil=$kayit["yil"]; $saat=$kayit["saat"]; $okundu=$kayit["okundu"]; if ($okundu != 0) $yeni = "<b>(Sıcak)</b>"; else $yeni = ""; echo " <tr> <td width=\"27\"><center> <input name=\"id[]\" class=inp type=\"checkbox\" id=\"$id\" value=\"$id\"></td> <td width=\"103\"> <a href=?isinla=msjoku&id=$id>$gonderen</a></td> <td width=\"326\"> <a href=?isinla=msjoku&id=$id>$konu $yeni</a></td> <td width=\"130\"> <a href=?isinla=msjoku&id=$id>$gun/$ay/$yil $saat</a></td> </tr> "; } echo " </tr> </table></td> </tr> </table> <input type=hidden name=ok value=ok> <input class=\"but\" type=\"submit\" name=\"tsil\" value=\"Sil\" onclick=\"top.main.location.href='sozluk.php?isinla=privmsg'\" accesskey=v> <input class=\"but\" type=\"button\" name=\"tsil\" value=\"Tümünü Sil\" onclick=\"top.main.location.href='sozluk.php?isinla=privmsg&silanam=tumunusil'\" accesskey=s> <input class=\"but\" type=\"button\" name=\"arsivle\" value=\"Arsivle\" onclick=\"top.main.location.href='?isinla=privmsg&islem=msjtasi&id=$id'\" accesskey=a> </FORM>"; } else { echo "\$u anda yeni bir mesajın yok malesef. sanırsam ki sanıyorum, kimse seni sevmiyor gibime geldi benim... bilemeyeceğim artık."; } ?>olarak dene