Display username (not your own) on non-vb pages

[Digma]

Thank you for responding to my thread Lynne, much appreciated and my apologies for not being thorough enough on the information given. Basically my situation is as followed:

I am currently working with 2 databases:
1. The forum database is where all the vbulletin information resides.
2. The site database is where all the site (so non-vb) information resides.

Mind that I have been fiddling around with the code to see what works. In an earlier part of the code below I have already included global.php and also have a login system that shows the person logged in.

However in relation to the code below I changed the author_id in the SITE database to reflect another user. When loading the code it still shows my username, not the one it should really relate to. Also when I logout I get to see Unregistered.

The last couple of line is what is currently troubling me to solve. Perhaps I am missing something stupidely simple and I just need to be pointed into the right direction or there is simply something fundamentally wrong with those few lines.

PHP Code:

       <?

            $query="select b.id, b.publicationdate, b.title, b.shortdesc, b.cat_id, b.author_id, c.naam from si_news b, si_news_cat c where b.publicationdate <= now() and c.id = b.cat_id order by b.publicationdate desc limit 0,10";

            $result = mysql_query($query);

            while ($row = mysql_fetch_array($result))

            {

            $row[publicationdate]=change_date($row[publicationdate]);

            echo "<P><H1>".$row['title']."</H1>";

            echo "<H3>".$row[publicationdate]."</H3>";

            echo $row['shortdesc']." <a href=\"blabla.com\">Read More</a><br>";

            echo "<H2>Category: ".$row['naam']; 

            $row['author_id']=$vbulletin->userinfo['userid'];

            echo " Author: ".$vbulletin->userinfo['username']."</H2></P>";

            }

        ?>

Note: I am not a real coder, so it might not be up to the standard of info you're used to. If you need more just let me know.

Thank you in advance.