multidimensional array from database table

[wpeloquin]

I am having trouble getting multiple rows from a table to display.

This is where i am currently at...
In my plugin php code i have the following:

// This will be in the form of page.php?do=action&user=1
$rkc_getuserid = $vbulletin->input->clean_gpc('r', 'user', TYPE_UINT);

$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) . "'
");

$rkc_char['char_id'] = htmlspecialchars($rkc_char['char_id']);
$rkc_char['char_name'] = htmlspecialchars($rkc_char['char_name']);
$rkc_char['char_race'] = htmlspecialchars($rkc_char['char_race']);
$rkc_char['char_class'] = htmlspecialchars($rkc_char['char_class']);

...

$templater->register('rkc_allchar', $rkc_allchar);
$templater->register('rkc_char', $rkc_char);


then in my template, i have the following:

<tr>
<vb:each from="rkc_allchar" value="char">
<td>{vb:raw char}</td>
</vb:each>
</tr>

The above code will successfully pull 1 row of data from the table. but if the user has multiple rows to pull, the other rows will not display. if i change from="rkc_allchar" to from="rkc_char" i get no data displayed at all.

I am pretty sure this has something to do with making a multidimensional array, but i am not sure how exactly to do this. I have trolled multiple php and vb sites but none of them give me enough to know how to do this when pulling multiple rows with multiple fields from a database.

What I am looking to do is something like:

<vb:each from="?" value="?"> // This will create a new row for each row of data collected
<tr>
<vb:each from="rkc_allchar" value="char"> // This will break down each field from the row into its own <td>
<td>{vb:raw char}</td>
</vb:each>
</tr>
</vb:each>


I assume the array will have to look something like:

char_array(
char1(
char_id => $variable,
char_name => $variable,
char_race => $variable
char_class => $variable
),
char2(
char_id => $variable,
char_name => $variable,
char_race => $variable
char_class => $variable
),
char3(
char_id => $variable,
char_name => $variable,
char_race => $variable
char_class => $variable
)
);

[Lynne]

You are using query_first which will only get you one row of data. You need to do a query_read in order to get all the rows.

[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!

[Lynne]

Have you tried doing a search in the default vbulletin files for some code that is an example of what you want?

[wpeloquin]

i posted my solution as an edit to my last post. Thanks for the help!

[Lynne]

Thanks for posting the solution and I'm glad you got it figured out. :)