rastaman46 Posted April 16, 2012 Share Posted April 16, 2012 hello again sorry for to many post but im still new in php here sql im run SELECT t.tid, t.info_hash, t.name, t.description, t.cid, t.size, t.added, t.leechers, t.seeders, t.times_completed, t.owner, t.options, t.nfo, t.sticky, t.flags, t.mtime, t.ctime, t.download_multiplier, t.upload_multiplier, t.external, t.tags, r.cname, u.membername, m.groupname, m.groupstyle FROM tsue_membergroups AS m Inner Join tsue_members AS u ON u.membergroupid = m.membergroupid Inner Join tsue_torrents AS t ON t.owner = u.memberid Inner Join tsue_torrents_categories AS r ON t.cid = r.cid WHERE upper(name) LIKE '%%' and `t.cid` IN(1) and error im get #1054 - Unknown column 't.cid' in 'where clause' Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted April 16, 2012 Share Posted April 16, 2012 The correct syntax for using back-ticks would be `t`.`cid` However, since you don't need to use back-ticks unless your table/alias or column name requires special handling, why use them at all and in that one single place in your query? Quote Link to comment Share on other sites More sharing options...
rastaman46 Posted April 16, 2012 Author Share Posted April 16, 2012 Well im trying make search with multiple checkbox Quote Link to comment Share on other sites More sharing options...
Muddy_Funster Posted April 17, 2012 Share Posted April 17, 2012 Well im trying make search with multiple checkbox what's that got to do with the price of oil? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.