Cytat(mysql_error)
mySQL error: 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 'mod
LEFT JOIN _forums f ON(f.id=mod.forum_id)
' at line 3
LEFT JOIN _forums f ON(f.id=mod.forum_id)
' at line 3
Ktoś miał może już podobny problem? Skąd jest odpalane to zapytanie? Pełna jego treść brzmi:
Cytat(mysql_query)
SELECT m2.id, m2.name, m2.email, m2.hide_email, m2.location, m2.aim_name, m2.icq_number,
f.id as forum_id, f.read_perms, f.name as forum_name, c.state
FROM _moderators mod
LEFT JOIN _forums f ON(f.id=mod.forum_id)
LEFT JOIN _categories c ON(c.id=f.category AND c.state != 0)
LEFT JOIN _members m2 ON (mod.member_id=m2.id)
f.id as forum_id, f.read_perms, f.name as forum_name, c.state
FROM _moderators mod
LEFT JOIN _forums f ON(f.id=mod.forum_id)
LEFT JOIN _categories c ON(c.id=f.category AND c.state != 0)
LEFT JOIN _members m2 ON (mod.member_id=m2.id)
Szukałem po moich plikach ale nic nie znalazło...
