[Logician]

Originally Posted by ged

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.

I believe this should work:

SELECT threadid, LEFT(title, 20) as title, dateline
FROM thread
WHERE sticky=0 AND visible=1 AND forumid=6
ORDER BY dateline DESC
LIMIT 5