| Chez |
26th February 2013 17:14 |
You can try this:
Put this code in details.php where do you want to show it:
PHP Code:
////////////// Similar Torrents/////////////////////
$s2 = substr($s, 0, 9);
$r = mysql_query("SELECT id, name, size, seeders, leechers, category FROM torrents WHERE name LIKE '$s2%' AND name !='$s' AND seeders !='0' ORDER BY name") or sqlerr();
if (mysql_num_rows($r) > 0)
{
$torrents = "<table width=100% class=main border=1 cellspacing=0 cellpadding=5>\n" .
"<tr><td class=tabletorrent>Name</td><td class=tabletorrent align=center>Größe</td><td class=tabletorrent align=center><img src=pic/up.png border=0></td><td class=tabletorrent align=center><img src=pic/down.png border=0></td></tr>\n";
while ($a = mysql_fetch_assoc($r))
{
$name = $a["name"];
$smallname3 =substr(htmlspecialchars($a["name"]) , 0, 100);
if ($smallname3 != htmlspecialchars($a["name"])) {
$smallname3 .= '...';
}
#$smallname3 = htmlspecialchars($a["name"]);
$torrents .= "<tr class=highlight><td><a href=details.php?id=" . $a["id"] . "&hit=1>$smallname3</a></td><td style='padding: 1px' align=center>". mksize($a[size]) ."</td><td style='padding: 1px' align=center>$a[seeders]</td><td style='padding: 1px' align=center>$a[leechers]</td></tr>\n";
}
$torrents .= "</table>";
print("<tr class=\"row2\" align=center><td class=row2>similarFiles</td><td align=left>$torrents</td></tr>\n");
}
/////////////////////////////////////////////////////////
|
