MySQL Not grabbing everything for my hack?

[Ryan Ashbrook]

This is why I hate working with MySQL.

I'm translating a hack from wBB 1.2 to vB 3.0.3 so that I can use it on my forums.

Problem is, I think I'm using the right code, but the SQL query is only grabbing one of the objects in the table, and not all of them.

PHP Code:

$thread_sword = $DB_site->query_first("SELECT sword FROM user WHERE userid='$bbuserinfo[userid]'");
$result = $DB_site->query("SELECT id, swordname, money FROM swords ORDER BY id ASC");
while ($item = $DB_site->fetch_array($result))
{
    $sword = $item[swordname];
    $money = $item[money];
    $id = $item[id];
} 


That is the code I'm using, and when I try to get the 44 objects from the table it only shows the one with an ID of 44, instead of all of the objects.