Location: PHPKode > scripts > OekakiPoteto > oekakipoteto/lcommentdel.php
<html>
<?
include('header.php');
$result5 = mysql_query("SELECT count(postdate) as rowno FROM ".$OekakiPoteto_Prefix."oekakicmt where usrname='$OekakiU'");
$rownum2 = mysql_result($result5, 0, 'rowno');
$pages = intval($rownum2/10) + 1;
$rsql = "SELECT postdate as rowno FROM ".$OekakiPoteto_Prefix."oekakicmt where usrname='$OekakiU' LIMIT ".($pageno*10).", 10";
$result5 = mysql_query($rsql);
$rownum = mysql_numrows($result5);
$rsql2 = "SELECT * FROM ".$OekakiPoteto_Prefix."oekakicmt where usrname='$OekakiU' order by postdate DESC LIMIT ".($pageno*10).", 10";
$result2 = mysql_query($rsql2);
$i = 0;
?>
<p></p>
<br>
<br>
<table width="<?=$hWidth?>" cellpadding="<?=$hCellPadding?>" align="center" cellspacing="2" class="infotable">
  <tr> 
    <td><font size="-2"><?=$langop_common_moveto?>: 
      <? WHILE ($i4 < $pages):?>
      [ <a href="lcommentdel.php?pageno=<?=$i4?>">
      <?=$i4+1?></a> ]
      <? 
$i4++;
endwhile;?>
      </font><br>
      <table width="100%" border="0" cellspacing="1" cellpadding="4" class="infotable">
        <tr> 
			  <td colspan="5" class="header"><?=$langop_lcommdb_title?></td>
        </tr>
        <? 
WHILE ($i < $rownum):
?>
        <tr> 
          <td width="7%"> 
            <div align="center"> 
              <?=mysql_result($result2,$i,"PIC_ID");?>
            </div>
          </td>
          <td width="7%"> 
            <div align="center"><a href="editcomm.php?id_3=<?=mysql_result($result2,$i,"ID_3");?>"><?=$langop_word_edit?></a></div>
          </td>
          <td width="19%"> 
            <div align="center">
              <?=mysql_result($result2,$i,"postdate");?>
            </div>
          </td>
          <td width="28%"> 
            <div align="center">
             <b><?=$langop_word_comment?>:</b> <?=nifty2_convert(mysql_result($result2,$i,"comment"));?>
              </div>
          </td>
          <td width="12%"> 
            <div align="center"><a href="functions.php?mode=udelcmt&cmtno=<?=mysql_result($result2,$i,"ID_3");?>"><?=$langop_word_delete?></a></div>
          </td>
        </tr>
        <?
$i++; 
endwhile; 
mysql_close($dbconn);

?>
      </table></td>
  </tr>
</table>
<br>
<br>
<? include('footer.php'); ?>
</body>
Return current item: OekakiPoteto