Location: PHPKode > scripts > OekakiPoteto > oekakipoteto/ldelpics.php
<html>
<?
include('header.php');
$result5 = mysql_query("SELECT count(ID_2) as rowno FROM ".$OekakiPoteto_Prefix."oekakidta where usrname='$OekakiU'");
$rownum2 = mysql_result($result5, 0, 'rowno');
$pages = intval($rownum2/10) + 1;
$rsql = "SELECT postlock, ID_2 as rowno FROM ".$OekakiPoteto_Prefix."oekakidta where usrname='$OekakiU' and postlock='1' LIMIT ".($pageno*10).", 10";
$result5 = mysql_query($rsql);
$rownum = mysql_numrows($result5);
$rsql2 = "SELECT * FROM ".$OekakiPoteto_Prefix."oekakidta where usrname='$OekakiU' and postlock='1' order by ID_2 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><table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
          <td> <b><font size="-2"><?=$langop_common_moveto?>: 
            <? WHILE ($i4 < $pages):?>
            [ <a href="ldelpics.php?pageno=<?=$i4?>"> 
            <?=$i4+1?>
            </a> ] 
            <? 
$i4++;
endwhile;?>
            </font></b><br>
            <table width="100%" border="0" cellspacing="1" cellpadding="4" class="infotable">
              <tr> 
                <td colspan="6" class="header"><?=$langop_lpicdb_title?></td>
              </tr>
              <? 
WHILE ($i < $rownum):
?>
              <tr> 
                <td width="7%"> 
                  <div align="center"> 
                    <?=mysql_result($result2,$i,"PIC_ID");?>
                  </div>
                </td>
                <td width="13%"> 
                  <div align="center"> <a href="editpic.php?picno=<?=mysql_result($result2,$i,"PIC_ID");?>"><?=$langop_word_edit?></a> 
                  </div>
                </td>
                <td width="16%" > 
                  <div align="center"> 
                    <?=mysql_result($result2,$i,"postdate");?>
                  </div>
                </td>
                <td width="16%"> 
                  <div align="center"><a href="<?=$OPpics?>/<?=mysql_result($result2,$i,"PIC_ID");?>.png" target="okpic"> 
                    <?=nifty2_convert(mysql_result($result2,$i,"title"));?>
                    </a></div>
                </td>
                <td width="22%"> 
                  <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="delconf.php?mode=del&picno=<?=mysql_result($result2,$i,"PIC_ID");?>"><?=$langop_word_delete?></a></div>
                </td>
              </tr>
              <?
$i++; 
endwhile; 
mysql_close($dbconn);
?>
            </table>
      
    </td>
  </tr>
</table>
</td>
  </tr>
</table>
<br>
<br>
<? include('footer.php'); ?>
</body>
Return current item: OekakiPoteto