View Single Post
  #14  
Old 29th November 2018, 15:39
Napon Napon is offline
Banned
 
Join Date: Feb 2016
P2P
Posts: 522
Default
Code:
"IF(torrents.numratings < $minvotes, NULL, ROUND(torrents.ratingsum / torrents.numratings, 1)) AS rating, categories.name AS cat_name, categories.image AS cat_pic, users.username FROM torrents LEFT JOIN categories ON category = categories.id LEFT JOIN users ON torrents.owner = users.id $where$orderby$limit$class"; 
    "categories.name AS cat_name, categories.image AS cat_pic, users.username, users.class FROM torrents LEFT JOIN categories ON category = categories.id LEFT JOIN users ON torrents.owner = users.id $where$orderby$limit$class"; 
    $res = sql_query($query) or die(mysql_error());  
Reply With Quote