While loop only getting one row?

[Mickie D]

Hi guys,

I can do this without vbulletin but as soon as I do this in vbulletin it only pulls one row

There is 6 rows it should pull from the database?

PHP Code:

    $dirsql = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "web WHERE file_userid = '$r1'");

        while ($array = $db->fetch_array($dirsql)){
 
                    
                    $filerows = '<h2 style="color: #3B4F9F;">'
                    .$array['file_name'].
                    '</h2><b>File Size: </b>' 
                    .formatBytes($array['file_fullsize']).
                    ' - <b>Last Modified: </b>'
                    .$array['file_timestamp'].
                    '<br /><a href="webspace.php?deletefile='
                    .$array['file_id'].
                    '"><u>Delete File</u></a> - <a href="webspace.php?u='.$vbulletin->userinfo['username'].'&filedownloadid='
                    .base64_encode($array['file_name']).
                    '"><u>Download File</u></a><br /><br />';
            } 


Thank you all in advance

Mick