Need support for modifications

Hello,


i hope to get some help and support in here, caus i really did not managed to workout my problem. I saw many similar questions and threads around here. But i a question asked nearlky the same..there was no answers..and if a question dont fit my problem there was a workout and the thread starter managed his problem..so since i began workout his.. i didnt find any (further) assistance in this big forum

ok..lets go on
..to show you an example of my webseite to understand it better..please go here:
spieleplanet.com
on this site you see the news system. It collects last entries of several tables in my database.

On this site you see an entry on its own if you cklick a link on the news site or summary page:
detail page.

Short explanations:
So you already saw that this pages are non-vb pages. First step of my problem is following -> i post a review in the database and after the posting of a new review it shows up in this news site and detailpage if you cklick the link on the news site.

now i did not manage it till now, to make a written review discuss-able in my forums..that means .. if i post a new review i have to open seperatly a new thread to get users in it and disussing my written review..but on this way.. there are not much users .. who detects this thread to discuss it....there is no connection between written review and thread

This feature i am trying to workout:
.. what i am trying is following-> i want to posts as usal my review..then it shows up in the news and detailpage if you cklick it..ok so far..it is everything working fine..but now i dont want to post only the review..no i have to manage that when i post a new review..automatically a new thread is started , for ex. in forumid=304, and the link to the review-discussion is showing up in the review itself (on detail page)..that means..no matter how many reviews are written..depending on the genre and review type there should be a thead created to make a review more dynamic, dscussable and more integrated in the forum.

So now the second step i am trying is this -> after posting a review with its created discussing thread in forumID=x i would be able to show the latest "Review discussion-threads" on the same news site i show you in the beginning of this thread.

For that i only need help or a tip for a sql query, so its not really a problem..but if i manage that.. i also can show up latest threads of forumID=x on this news page..so i would be able to say "this is really an news page".. and not only a news page for non-vb content..is there any possibility to merge non-vb news with vb-news (vb-news = latest threads in forumID=x)

Please look here:
Could this be the code on a non-vb page for latest threads in forum-idX

PHP Code:

$sql = "SELECT threadid, title, forumid, replycount, postusername, postuserid, lastposter, dateline, iconid FROM thread WHERE forumid = 304 ORDER BY threadid DESC LIMIT 10"; 


should this be an example..and a working wuerie to show up on non-vb pages latest threads of forumID=304 ? .. so i cozuld show up any forum section if i change the forumD..

ok .. enough explanation and writing.. i really hope that someone around here reads this and is able to help if i wants to help..

Banner button is no problem if you want one to show up a a partner link (8.000 to 10.000 visitors)..really no problem to give you that...

greets
Highlander