Nested selects also will not do this trick i think.

Even if I could get the query to display the latest single post in each forum and then sort by forum name I would be happy.

Right now I can get it to display a single post from each forum and sort by forum, but it's displaying the oldest post in the forum and not the latest.

SELECT t.threadid, t.title, t.firstpostid, t.lastpost, f.title as forumtitle, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, p.pagetext, t.iconid, t.forumid
FROM thread t
LEFT JOIN post p ON p.postid = t.firstpostid
LEFT JOIN forum f ON f.forumid = t.forumid
WHERE t.forumid
IN ( 19, 116 )
AND t.open = '1'
AND t.visible = '1'
GROUP BY f.title
ORDER BY forumtitle DESC
LIMIT 0 , 3

Maybe add a ORDDR BY t.dateline DESC to it

Tried that but the query does not like 2 ORDER BY lines.

I also tried removing the ORDER BY line and adding:


ORDER BY t.dateline ASC

or

ORDER BY t.dateline DESC

Both lines in the query still bring up the oldest (first) thread in the forum and not the latest thread. :disappointed:

Change To:

When I use:

The forums are not in order and the posts are not the last posts.

When I use:

The forums are in order but it's still showing the first posts (not the latest ones).

@Sportbikeworld : I don't think it is possible to grab the data you want with one query. I'd suggest to give up and use multiple webqueries to compile this data. I think you don't want to increase the query count of your webtemplate with a single query for each forum but this shouldn't cause a big performance problem so try it.

@Spinball : Webtemplate PHP parsing is exactly same as vbulletin's PHP parsing in phpinclude template and you are not able to use the other webtemplate features in a PHP parsed webtemplate like automatic header/footer inclusion. However you should consider:
a) If your PHP code is basic : Make your webtemplate parsing TXT or HTML (instead of PHP) and run your PHP code inside PHP parsed template of webtemplate.
b) If your PHP code is advanced : Grab vb header and footer inside your PHP code with PHP commands as well like:

eval('$headinclude = "' . fetch_template('headinclude') . '";');
eval('$header = "' . fetch_template('header') . '";');
eval('$footer = "' . fetch_template('footer') . '";');

Darn, I have over 150 forums and need to query just about all of them. I was hoping to not have to re-enter a webquery for each one.

I wish you had a way to copy a default query over and over in the admin area.

Thanks for the help though. Still very happy with the hack. :)

Thanks, Logician.
I did as you suggested and got a header and footer. No navbar, page title or page in a category table, though.
What I want to do is run a fairly complex PHP script which allows people to search for a make & model of DVD player, read the hacks for it, comment and provide feedback on those hacks and submit and edit new ones.
All while maintaining the logged-in appearance of the forums. I want to write the user id to any comments/hacks records they contribute and display their user name from the vB database in the displayed records.
Now writing that script is well within my capabilities. Having it all happen within the forum 'environment' is not.
Help!
Thanks.

Hey Logician!

Got the following error when trying to update the database. Ran it both ways. Know what this means?

==============
Error

SQL-query :

--

MySQL said:
#1064 - You have an error in your SQL syntax near '--' at line 1
===============

Clark