ciao!
ho un problema di query mi dice che c'e' un errore , ma sinceramente non riesco a capire qual'e'!!
query:
SELECT f.id AS id, f.forum_name AS forum, f.forum_desc AS description, count( forum_id ) AS threads, u.name AS mod
FROM forum_forum f
LEFT JOIN forum_posts p ON f.id = p.forum_id
AND p.topic_id =0
LEFT JOIN forum_users u ON f.forum_moderator = u.id
GROUP BY f.id
LIMIT 0 , 30
Messaggio di MySQL: Documentazione
#1064 - 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
FROM forum_forum f
LEFT JOIN forum_posts p
ON f.id = p.forum_id
' at line 3
.. boh
!
grazie infinite ! !
Luca
Rispondi quotando
