- Joined
- Jul 12, 2011
- Messages
- 1,229
- Reaction score
- 475
i've tried and I think it won't let me because it already has a join guild?
Code:g.logoBG AS logoBG FROM characters c LEFT JOIN guilds g ON c.guildid = g.guildid WHERE c.gm < $gmlevel
because i've tried doing
Code:a.banned AS banned FROM characters c LEFT JOIN accounts a ON c.accountid = a.id WHERE c.gm < '$gmlevel' AND banned = 0
but it keeps giving an error saying I am not allowed and shows the g.logoBG line
Can you post the error? Also, it is much easier to debug queries in a MySQLI gui/cli app, instead of wrangling with it in PHP.