PHP - Modulus

I can't seem to get the math right!

I have a function, pulling 13 states (canadian provinces) from the database and I can't seem to get them all to show in 5 columns. Where am I doing this wrong. The code below only shows 7 of 13... I just can't seem to get where I am off!

PHP CODE:
function map_showCA()
{
global $db, $tpl;

// ShowLocalResources

$sSQL = "SELECT * FROM states_canada ORDER BY state;";
$db->query($sSQL);
$next_record = $db->next_record();

while ($next_record)
{
$state_id = $db->f("id");
$state = $db->f("state");
$statename = $db->f("statename");
$statename_html = $db->f("statename_html");

$next_record = $db->next_record();
if (!USE_SEO_LINKS) { $statename_html = $state_id; }
$vendors_states[] = array("name" => $statename, "id" => $state_id, "state_html" => $statename_html);
}

$vendors_states_col = array_chunk($vendors_states, 5, true);

$loop = (int)(count($vendors_states) / 5);
if(count($vendors_states) % 5 > 0) $loop++;

$j = 0;

for($i = 0; $i < $loop; $i++)
{
$parameters = 'http://'.$vendors_states_col[0][$j]["state_html"].'.ilocalize.com';
// $first_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("first_column_link", $parameters);
$tpl->set_var("first_column", tohtml($vendors_states_col[0][$j]["name"]));

$parameters = 'http://'.$vendors_states_col[1][$j+6]["state_html"].'.ilocalize.com';
// $second_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("second_column_link", $parameters);
$tpl->set_var("second_column", tohtml($vendors_states_col[1][$j+6]["name"]));

$parameters = 'http://'.$vendors_states_col[2][$j+12]["state_html"].'.ilocalize.com';
// $threeth_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("threeth_column_link", $parameters);
$tpl->set_var("threeth_column", tohtml($vendors_states_col[2][$j+12]["name"]));

$parameters = 'http://'.$vendors_states_col[3][$j+18]["state_html"].'.ilocalize.com';
// $fourth_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("fourth_column_link", $parameters);
$tpl->set_var("fourth_column", tohtml($vendors_states_col[3][$j+18]["name"]));

$parameters = 'http://'.$vendors_states_col[4][$j+24]["state_html"].'.ilocalize.com';
// $fifth_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("fifth_column_link", $parameters);
$tpl->set_var("fifth_column", tohtml($vendors_states_col[4][$j+24]["name"]));

$tpl->parse("ShowLocalResourcesCA", true);
$j++;
}
}

HTML CODE:
Code: [Select]
<table border="0" cellpadding="1" cellspacing="1"  class="description_text2"  style="padding-bottom:6px;" width="100%" id="dashed_box_gray">
             <!--BeginShowLocalResourcesCA-->
                <tr>
                    <td width="110" align="left" style="padding-left:6px; padding:6px;"><a href="{first_column_link}" class="user_blue_14px">{first_column}</a></td>
                    <td width="109" align="left" style="padding-right:6px; padding:6px;"><a href="{second_column_link}" class="user_blue_14px">{second_column}</a></td>
                    <td width="109" align="left" style="padding-right:6px; padding:6px;"><a href="{threeth_column_link}" class="user_blue_14px">{threeth_column}</a></td>
                    <td width="109" align="left" style="padding-right:6px; padding:6px;"><a href="{fourth_column_link}" class="user_blue_14px">{fourth_column}</a></td>
                    <td width="108" align="left" style="padding-right:6px; padding:6px;"><a href="{fifth_column_link}" class="user_blue_14px">{fifth_column}</a></td>
                </tr>
                <!--EndShowLocalResourcesCA-->
                </table>