Displaying latest Thread on a diff .php page

[Jacko]

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

[Andreas]

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

[Jacko]

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.

[Andreas]

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.

[Jacko]

how do i access the diff connection then??