[TouchingVirus]

Here is another one that has me half-stumped!

In vbulletin, especially, when i do custom queries, i usually get multiple rows of results..

Rather like this little snippet..

PHP Code:

$user = $DB_site->query("SELECT * FROM user WHERE userid < 5");
$username = $user['username']; 


This returns 4 rows if you have more than 5 users. The problem i have is to get it to display on a php page..

for instance, in that peice of code i want to display the usernames as follows in a template..

Username1
Username2
Username3
Username4

so in the template i put in this..

<table><td><strong>$username</strong></td></table>

Yet this will only display one username, not all 4 as i want it to appear..any ideas on how to print all 4?