Array Help

[evilthoutz]

Hello I am trying to create an array to list the results that it finds from the MySQL DB using the SELECT command.

Here is my code basically, im new to vBulletin + PHP.

$theuserid = $vbulletin->userinfo['userid'];
$result = $vbulletin->db ->query_read("SELECT * FROM vsa_advreg_invite WHERE inviter='$theuserid'");
while($row = $vbulletin->db->fetch_array){
$getcode =  "You invited: " . $row['invited']. "<br> Your Code to Give: ". $row['code'] . "<br>";
}