Thanks$sql_news = mysql_query('SELECT thread.threadid, thread.title, thread.forumid, thread.firstpostid, thread.lastpost, thread.dateline, thread.postusername, thread.postuserid, thread.replycount as commentcount, thread.iconid, thread.lastposter as newscommentname, avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline, post.pagetext as newstext, icon.title as icontitle, icon.iconpath as iconpath
FROM thread
LEFT JOIN post ON(thread.firstpostid = post.postid)
LEFT JOIN user ON(thread.postuserid = user.userid)
LEFT JOIN avatar ON(user.avatarid = avatar.avatarid)
LEFT JOIN customavatar ON(user.userid = customavatar.userid)
LEFT JOIN icon ON(icon.iconid = thread.iconid)
WHERE (thread.forumid = '1' AND thread.open='1')
ORDER BY thread.dateline DESC LIMIT 5');
unexpected T_LNUMBER error in query.
Moderator: General Moderators
unexpected T_LNUMBER error in query.
Any idea what might be wrong with this sql query? (using mySQL). The line throwing the error is in bold.
