[Logician]

Originally posted by grb123
Webqueries query:

I currently have the last 10 thread titles from my forum on a page. I have the query as follows:

SELECT threadid, title, FROM thread WHERE visible='1' AND forumid='1' ORDER BY title LIMIT 10

which shows the last 10 threads. How can I make the threadtitle no more than 28 characters?

You can use this query:

SELECT threadid, left(title,28) as title1 FROM thread WHERE visible='1' AND forumid='1' ORDER BY title LIMIT 10

Dont forget to use ??title1?? in your tablerow