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' Link to comment https://forums.phpfreaks.com/topic/261050-sql-error/ 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? Link to comment https://forums.phpfreaks.com/topic/261050-sql-error/#findComment-1337881 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 Link to comment https://forums.phpfreaks.com/topic/261050-sql-error/#findComment-1337883 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? Link to comment https://forums.phpfreaks.com/topic/261050-sql-error/#findComment-1338055 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.