$r = mysql_query("SELECT snatched.torrent_name as name, snatched.torrentid as id, snatched.torrent_category as category, snatched.uploaded, snatched.downloaded, snatched.completedat, snatched.last_action, torrents.seeders, torrents.leechers FROM snatched JOIN torrents ON torrents.id = snatched.torrentid WHERE snatched.finished='yes' AND userid=$id ORDER BY torrent_name") or sqlerr();
if (mysql_num_rows($r) > 0)
{
$completed = "\n" .
"\n";
while ($a = mysql_fetch_assoc($r))
{
$r2 = mysql_query("SELECT name, image FROM categories WHERE id=$a[category]") or sqlerr(__FILE__, __LINE__);
$a2 = mysql_fetch_assoc($r2);

if ($a["downloaded"] > 0)
{
$ratio = number_format($a["uploaded"] / $a["downloaded"], 3);
$ratio = "$ratio";
}
else
if ($a["uploaded"] > 0)
$ratio = "Inf.";
else
$ratio = "---";
$uploaded =mksize($a["uploaded"]);
$downloaded = mksize($a["downloaded"]);
$cat = "";
$completed .= "" .
"\n";
}
$completed .= "

Type	Name	Seeders	Leechers	Uploaded	Downloaded	Ratio	When Completed	Last Action
$cat	" . htmlspecialchars($a["name"]) . "	$a[seeders]	$a[leechers]	$uploaded	$downloaded	$ratio	$a[completedat]	$a[last_action]

";
}