Fetch Row isn't grabbing all data in row

[kh99]

You are overwriting the value of $ffname every time through the loop, so that in the end it is just set to the last name, as you saw. You could do this:

$result = $db->query_read("SELECT * FROM uksfroster");
  
while ($fname = $vbulletin->db->fetch_row($result)){
    $ffname .= $fname[1] . '<br />';
}
$templater->register('firstname', $ffname);

Then you should see them all. You could also render a small template inside the loop to format the data for each user, so that you wouldn't need to have any html in the code.

Another way to do it would be to use the vb4 loop template tags. WHat you'd do is build an array of the names, register that to the template, then put the loop tags in the template, like:

$result = $db->query_read("SELECT * FROM uksfroster");
  
while ($fname = $vbulletin->db->fetch_row($result)){
    $ffname[] = $fname[1];
}
$templater->register('firstname', $ffname);

Then in the template:

<vb:each from="firstname" key="key" value="username">
   Name: {vb:var username}<br />
</vb:each>