Need help querying the database & pulling info

[TerryMason]

I have a normal (non-VB) php page for my front / landing page. I'd like to be able to show the last 10 updated threads from forums 3,7,8,16,31. I want to pull the last post time, as well as other info, so using an RSS feed won't work - I need to pull from the database.

I'm a rookie with mysql, so I'm not exactly sure what the best way to go about this is. Does anyone have a code example to get me started? Also, should I have the database info inside of this file, or should I try to include one of my existing vb files (i.e. config.php)

Thanks for the help guys.

[Lynne]

There are a few modifications that show the Last 10 Update Threads... have you tried downloading one of them and looking at the code?

[TerryMason]

I have, but they don't seem to be a complete program, meaning they seem to call other functions that are built into vbulletin.

I need to find a way to access the database, and pull the data.

I had been working with this:




$mysql = mysql_connect(localhost);
mysql_select_db(DATABASE_NAME);
$user = $_GET['USER'];
$pass = $_GET['PASS'];


## GET LATEST THREADS ##
SELECT thread.*,thread.iconid AS threadiconid $previewfield
FROM ".TABLE_PREFIX."thread AS thread
LEFT JOIN ".TABLE_PREFIX."deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
$previewjoin
WHERE open <> 10
AND forumid NOT IN (0$limitfids)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost
DESC LIMIT 5");



and I think I'm able to get the data, but I don't know how to echo it to the screen.

[Anseur]

I would suggest you look at the 'how to create your own vbulliten page' article, and see if your can add the appropiate emelents of that to your landing/front page. then you can use a mod like that to take the data and put it into a variable, then make a template that is called by the page and then call the variable in that page.

failing that, you will need to learn some php to get from the database and ehco stuff onto your custom page. Either way, your going to need some coding experiance to do it.

[Lynne]

If you require global.php in your code, then you don't need to write the stuff about connecting to mysql.

Have you taken a look at the showthread.php page? It's going to have some very similar code to what you want.