Catigory search [message #110] |
Wed, 26 July 2006 14:34  |
|
i get mysql_error when a catigory is sellected
Error executing SQL Query SELECT torrent_torrents.*, IF(torrent_torrents.numratings
< '0', NULL, ROUND(torrent_torrents.ratingsum / torrent_torrents.numratings, 1)) AS rating, torrent_categories.name
AS cat_name, torrent_categories.image AS cat_pic, U.username, IF(U.name IS NULL, U.username, U.name) as user_name,
U.level as user_level FROM torrent_torrents LEFT JOIN torrent_categories ON category = torrent_categories.id
LEFT JOIN torrent_users U ON torrent_torrents.owner = U.id WHERE 1AND torrent_torrents.category =
1 ORDER BY torrent_torrents.evidence DESC, torrent_torrents.added DESC LIMIT 0,10;
Error ID: 1064
Error Message: You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'torrent_torrents.category = 1 ORDER BY torrent_torrents.evidence
DESC, torrent_t' at line 1
any clue's????
|
|
|
|
|