Displaying latest Thread on a diff .php page
 

I am running a store script over @ www.carstyledirect.com

and i want to display the top 5 latest threads on there, the script uses .html templates and is all .php driven.


Can this be done with an include etc....?

Thanks

Either you require the vBulletin backend or you do it manually:

[sql]
select * from thread where forumid=12 order by dateline desc limit 5
[/sql]

This will give you the last 5 threads started in forum id 5 in descending order

wouldnt i need to connect to a sep db also?? as the store db is seperate from the vb one.

and i aint to good at sql.

If you can access both DBs with the same mySQL account you can just switch the database. If you you will need a separate database connection.

how do i access the diff connection then??