orichec1000 |
26th April 2016 01:17 |
Arrangment of Torrents / Sql Query to sort Torrrents
Hello everyone,
I tried to sort Appz related torrents from database by calling table "category" but when i use sort by category using php it also mix up other torrents such as movies, Please guide me how can I sort torrents of only one category instead of all from table "category"...
Here is my php codes
PHP Code:
$orderby = "ORDER BY torrents.category DESC"; $addparam = ""; if ($_GET["incldead"] == 2) $wherea[] = "visible = 'yes'"; $res = mysql_query("SELECT COUNT(*) FROM torrents $where") or die(mysql_error()); $row = mysql_fetch_array($res,MYSQL_NUM); $count = $row[0]; if ($count) { $pager = pager($torrentsperpage, $count, "browse.php?" . $addparam); $query = "SELECT torrents.id, torrents.category, torrents.name, torrents.times_completed, torrents.size, torrents.added, torrents.type, torrents.comments,torrents.numfiles,torrents.filename,torrents.owner,IF(torrents.nfo <> '', 1, 0) as nfoav," . "categories.name AS cat_name, categories.image AS cat_pic, users.username FROM torrents LEFT JOIN categories ON category = torrents.id LEFT JOIN users ON torrents.owner = users.id $where $orderby {$pager['limit']}"; $res = mysql_query($query) or die(mysql_error());
Thanks
|