Members   Search      Help    Register    Login    Home
Home » Support Forums for PMBT 1.X » Development » Catigory search
icon1.gif  Catigory search [message #110] Wed, 26 July 2006 14:34 Go to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
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????


http://a.imageshack.us/img831/5562/mybikes.png
Re: Catigory search [message #111 is a reply to message #110] Wed, 26 July 2006 17:17 Go to previous messageGo to next message
cryptickilla4f is currently offline cryptickilla4f  United States
Messages: 11
Registered: July 2006
Location: Massachusetts
Leecher

Uh wish i knew.

[Updated on: Wed, 26 July 2006 18:28]

Report message to a moderator

Re: Catigory search [message #127 is a reply to message #110] Thu, 27 July 2006 21:37 Go to previous message
djechelon is currently offline djechelon  Italy
Messages: 207
Registered: June 2006
Location: Ercolano, NA
Releaser
Administrator

Fixed
  • Attachment: index.php
    (Size: 6.88KB, Downloaded 204 times)


Unfortunately, no one can be told what the Matrix is. You have to see it for yourself.
Next Topic:Introduction
Goto Forum:
  


Current Time: Sun Feb 05 08:08:51 GMT 2012

Total time taken to generate the page: 0.00637 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software