I have prepared a list with letterbar which let users to filter the threads. (Letterbar in
this post)
Everything works perfect. I've used the letterbar as below in the templates.
Code:
<a href='view.php?pg=cat1&myletter=a'>A</a>
<a href='view.php?pg=cat1&myletter=b'>B</a>
<a href='view.php?pg=cat1&myletter=c'>C</a>
I've also prepared a list which shows all the threads from all the categories. (cat1,cat2,cat3) I used below querry.
Code:
SELECT t.threadid, t.title, t.postusername,t.postuserid,t.dateline, f.title as forumtitle
FROM " . TABLE_PREFIX . "thread t
LEFT JOIN " . TABLE_PREFIX . "forum f ON f.forumid=t.forumid
WHERE t.sticky=0 AND t.visible=1 AND (t.forumid=1 OR t.forumid=2 OR t.forumid=3) $letterquery
ORDER BY t.dateline DESC
LIMIT 2000
I would like to learn if it possible to filter the threads of all categories with the same letterbar ?
What i mean is, i would like to be able to use a letterbar for the template which lists all the threads from category1, category2 and category3.
Is that possible ?
Regards