All pastes #586067 Raw Edit

Mine

public text v1 · immutable
#586067 ·published 2007-06-23 16:55 UTC
rendered paste body
<?
  $sql = mysql_query("SELECT * FROM mp3z ORDER BY `id` DESC LIMIT 20");
while($arr = mysql_fetch_assoc($sql))
  {
 
 
  $name = $arr["name"];
  $link = $arr["link"];
  $size = $arr["size"];
  $year = $arr["year"];
 $id = $arr["id"];
 $svaleno = $arr["svaleno"];
 
$sql1="SELECT COUNT(id) as broika FROM `komentari` WHERE idto=$id";
$query=mysql_query($sql1);
$row=mysql_fetch_array($query);
$broi=$row['broika'];

  ?>
  <tr>
    <td align="left" bgcolor="#4E4E4E"><a href="download.php?id=<?=$id?>" class="menu_link" onmouseover="return overlib('<b><?=$name?></b> / <?=$year?> / <?=$size?> / &#1042;&#1080;&#1076;&#1103;&#1085; - <?=$svaleno?>', CAPTION, '&#1048;&#1085;&#1092;&#1086;&#1088;&#1084;&#1072;&#1094;&#1080;&#1103;');" onmouseout="return nd();""><?=$name?></a></td>
    <td align="left" bgcolor="#4E4E4E"><?=$size?></td>
    <td align="left" bgcolor="#4E4E4E"><?=$year?></td>
    <td align="left" bgcolor="#4E4E4E"><div align="center"><span class="copyright">
        <?=$svaleno?>
    </span></div></td>
    <td align="left" bgcolor="#4E4E4E"><div align="center">
      <?=$broi?>
    </div></td>
  </tr>
  <?
  }
  ?>