Using vb to pull information from the database.

[BBR-APBT]

Ohh Lynne ohh Lynne where could you be I need help with my PHP. LMAO

I am trying to pull information from the database using vBulletin's existing structure.

My only problem is it only pulls one result.

// ######  Check query returns result #####
$result = $db->query("
    SELECT * 
    FROM " . TABLE_PREFIX . "glossary 
    WHERE LEFT(word,1)='$letter' ORDER BY word
");

// ##### Check if empty result #####
if (empty($result)) {
  $dataresult = "1";
}
 else {
  $dataresult = "2"; 
}

// ##### Display by-letter #####
while ($row = $db->fetch_array($result,MYSQL_NUM)) { 
$result .= "<tr><td class=\"dbtext\"><b>$row[1]</b></td><td class=\"dbtext\">$row[2]</td></tr>";
}

How would I put that into an array to show all?

I am using this to pull it in the template.

{vb:raw result}

Sorry for all the questions and thanks for any help.