Last X torrents

[DarkWarrior]

scrolls but no content...provided visual on two different pages

Code Select Expand

//== Start of Last X torrents with poster and marquee mod ==//
$query="SELECT id, name, poster FROM torrents WHERE poster <> '' ORDER BY added DESC LIMIT 10";
$result=mysql_query($query);$num = mysql_num_rows($result);
print("<table cellpadding=2 width=100% align=center><tr><td colspan=1 align=center>
<marquee scrollAmount=2 onmouseover=this.scrollAmount=0 onmouseout=this.scrollAmount=2 scrolldelay=50 direction=left>");
while ($row = mysql_fetch_assoc($result))  {
$id = $row['id'];
$name = $row['name'];
$poster = $row['poster'];
$name = str_replace('_', ' ' , $name);
$name = str_replace('.', ' ' , $name);
$name = substr($name, 0, 50);
if (!empty($poster)){
print("<a href=$BASEURL/details.php?id=$id title=$name><img class=glossy src=$poster width=120 height=180 title=$name border=0></a>");
} else {
print("<a href=$BASEURL/details.php?id=$id title=$name><img class=glossy src=pic/poster.jpg width=120 height=180 title=$name border=0></a>");
} } print("</marquee></td></tr></table>");
//== End of Last X torrents with poster and marquee mod ==//

[randomwoot]

scrolls but no content...provided visual on two different pages

[randomwoot]

Thanks...looks great!  Will give it a try

[rickandmary]

Code Select Expand

//Start of Last X torrents with poster and marquee mod
$query="SELECT id, name, poster FROM torrents WHERE poster <> '' ORDER BY added DESC LIMIT X";
$result=mysql_query($query);$num = mysql_num_rows($result);
print("<br>");
print("<h2>Last X Torrents</h2>");
print("<table cellpadding=2 width=100% align=center><tr><td colspan=1 align=center><marquee scrollAmount=3 onMouseover=this.scrollAmount=0 onMouseout=this.scrollAmount=3 scrolldelay=0 direction=left>");
while ($row = mysql_fetch_assoc($result))  {
$id = $row['id'];
$name = $row['name'];
$poster = $row['poster'];
$name = str_replace('_', ' ' , $name);
$name = str_replace('.', ' ' , $name);
$name = substr($name, 0, 50);
print("<a href=$BASEURL/details.php?id=$id title=$name><img src=$poster width=100 height=142 title=$name border=0></a>");
}
print("</marquee></td></tr></table>");
//End of Last X torrents with poster and marquee mod