SELECT s.*, cityname, abbrev, nickname, offstyle, defstyle
from fof7_staff s
LEFT JOIN fof_teams t on t.id=s.current_team
LEFT JOIN ben_offstyles o on o.offstyleid=s.offensive_style
LEFT JOIN ben_defstyles d on d.defstyleid=s.defensive_front
where staff_id= 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 '' at line 6 |