View Single Post
  #12  
Old 21st February 2010, 02:42
Timisoreanul's Avatar
Timisoreanul Timisoreanul is offline
Senior Member
 
Join Date: Apr 2008
P2P
Posts: 211
Default
Quote:
Nicky
code used poster or remove in query
Code:
 torrents.poster,
and
Code:
<img src=\"$arr1[poster]\" border=\"0\" width=\"150\" height=\"150\">
in your case step 6:
Code:
$res1 = mysql_query("SELECT torrents.id, torrents.size, torrents.name, torrents.filename, torrents.leechers, torrents.seeders, torrents.times_completed, torrents.owner, users.username AS username, users.class AS class FROM torrents INNER JOIN users ON torrents.owner = users.id WHERE torrents.recommend='yes' ORDER BY torrents.times_completed DESC LIMIT 3");
or
Code:
$res1 = mysql_query("SELECT torrents.id, torrents.size, torrents.name, torrents.filename, <img src=\"$arr1[poster]\" border=\"0\" width=\"150\" height=\"150\">, torrents.leechers, torrents.seeders, torrents.times_completed, torrents.owner, users.username AS username, users.class AS class FROM torrents INNER JOIN users ON torrents.owner = users.id WHERE torrents.recommend='yes' ORDER BY torrents.times_completed DESC LIMIT 3");
__________________
only me
Reply With Quote