multidimensional array from database table

[wpeloquin]

ah, ty for that. i changed that, but it is still not working properly.

Like i said, I am unsure how to structure the php code and the template code properly. i have tried multiple ways, and will keep trying to find an example/tutorial/etc on what im trying to do, but any help on the structure or what i'm doing wrong is appreciated.

----------------------------
EDIT: User Solved
----------------------------
PHP Code:

$rkc_allchar = $vbulletin->db->query_first("
	SELECT char_id, char_name, char_race, char_class
	FROM " . TABLE_PREFIX . "rkc_plugintable AS rkc_plugintable
	WHERE user_id = '" . $vbulletin->db->escape_string($rkc_getuserid) . "'
");

$count = 0;
while ($rkc_char = $vbulletin->db->fetch_array($rkc_allchar))
{
    $rkc_charlist[$count] = array(
        'char_id' => htmlspecialchars($rkc_char['char_id']),
        'char_name' => htmlspecialchars($rkc_char['char_name']),
        'char_race' => htmlspecialchars($rkc_char['char_race']),
        'char_class' => htmlspecialchars($rkc_char['char_class']),
    );
    $count++;
...

    $templater->register('rkc_charlist', $rkc_charlist);

    }

Template Code:

	<vb:each from="rkc_charlist" value="char">
	<tr>
		<td class="blocksubhead" style="width:15%;">{vb:raw char['char_id']}</td>
		<td class="blocksubhead" style="width:15%;">{vb:raw char['char_name']}</td>
		<td class="blocksubhead" style="width:15%;">{vb:raw char['char_race']}</td>
		<td class="blocksubhead" style="width:15%;">{vb:raw char['char_class']}</td>
	</tr>
	</vb:each>

Thank you for the help!