Pulling Infomation from The Database

**Stream** · 02-28-2009, 01:33 PM

Hey there, I'm in the process of making a new page for VB. I've followed tutorials from vb.org and the templates and everything work fine.

I've hit a but of a problem, I want to pull information from the database and display it on the new page, I've got this piece of code in the php file;

PHP Code:

  $last23 = $vbulletin->db->query_read("

    SELECT * FROM vbforum

    WHERE forumid = '23'

    ");  

 
    while ($info23 = $vbulletin->db->fetch_array($last23))

And in the template I have

Code:

$info23[lastposter]

Which does display the name of the last person to post in forum 23.

Now the thing is I want to be able to display the same info from more than one forum, If I add the code again to the php file and template just chaging the details to match, it will only display the info from the last forum specified instead of all of them.

What do I have to do to be able to display the info from all the forums I specify?

--Stream

**glennybee** · 02-28-2009, 05:02 PM

I'm by no means an expert at this stuff, I couldn't even as far as you've got right now.

But what if you put the code in a plugin instead of editing the php files? And set the hook location to a global_start, would that work on every page?

**Stream** · 03-01-2009, 12:12 AM

I've had a go at putting it in plugins but I can't seem to get it right, nothing is showing.

Does anyone know of a tutorial anywhere? I've had a look around and can't find one.

--Stream