Quote:
Originally Posted by mrkhm
thank you this works perfectly in vb 3.6.x
quick question for anyone is there anyway to limit it to only show titles from specific forums should i be doing
select * from where something something is = to something
thanks anyway
|
Change the MySQL query to:
[sql]
SELECT title, threadid FROM ". TABLE_PREFIX ."thread WHERE forumid IN (X, Y, Z) ORDER BY lastpost DESC LIMIT 10"[/sql]
Change [minicode]title, threadid[/minicode] to
* if you want to select all fields.
X, Y, Z Being a comma separated list of the ForumID numbers.