Hi, first of all, I'd like to say I've searched the entire topic to prevent double posting same problem.
I'm trying to modify webquery
WQ_lastxthreadfromforumy only to show thread title's first 20 characters:
PHP Code:
SELECT threadid, LEFT(title, 20), dateline
FROM " . TABLE_PREFIX . "thread
WHERE sticky=0 AND visible=1 AND forumid=6
ORDER BY dateline DESC
LIMIT 5
Can you tell me what I did wrong?
Thank you very much.