Nested Loop with templates

[Ghostsuit]

Heres the full page code with the suggested change made.

<?php

// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################

define('THIS_SCRIPT', 'giglist');
define('CSRF_PROTECTION', true);  
// change this depending on your filename

// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array('event_giglist',
'event_giglistrow',
'event_giglistrowticket',
);

// pre-cache templates used by specific actions
$actiontemplates = array();

// ######################### REQUIRE BACK-END ############################
// if your page is outside of your normal vb forums directory, you should change directories by uncommenting the next line
// chdir ('/path/to/your/forums');
require_once('./global.php');

// #######################################################################
// ######################## START MAIN SCRIPT ############################
// #######################################################################

$navbits = construct_navbits(array('' => 'Gig List'));
$navbar = render_navbar_template($navbits);

// ###### YOUR CUSTOM CODE GOES HERE #####
$pagetitle = 'Gig List';

// ###### NOW YOUR TEMPLATE IS BEING RENDERED ######
$results = $vbulletin->db->query_read("SELECT date_format(gig.date, '%a %D %b %y') AS gig_date, gig.gigid, venue.venuename AS gig_venuename, gig.title, gig.status, gig.age
FROM gig 
LEFT JOIN venue ON gig.venueid=venue.venueid
WHERE Status='confirmed' AND title != '' AND date  >= ( CURDATE()  ) ORDER BY date ASC");

// Loop through all results
while ($row = $vbulletin->db->fetch_array($results))
{   
    // Generate row html from template
    $templater = vB_Template::create('event_giglistrow');
    $templater->register('gigid', $row[gigid]);
    $templater->register('title', $row[title]);
    $templater->register('venuename', $row[gig_venuename]);
    $templater->register('date', $row[gig_date]);
    $templater->register('age', $row[age]);
    
    $linkresults = $vbulletin->db->query_read("SELECT ticketlink
    FROM ticketlink 
    LEFT JOIN gig ON ticketlink.gigid=gig.gigid
    WHERE ticketlink.gigid=gig.gigid AND ticketlink.gigid = '$row[gigid]'");

    while ($linkrow = $vbulletin->db->fetch_array($linkresults))
    {      
        $templater = vB_Template::create('event_giglistrowticket');
        $templater->register('linkrow', $linkrow);
        $event_giglistrowticket .= $templater->render();
    }
    $event_giglistrow .= $templater->render();
}


// Optionally free memory
$vbulletin->db->free_result($results);
unset ($result_row);

$templater = vB_Template::create('event_giglist');
$templater->register_page_templates();;
$templater->register('event_giglistrow', $event_giglistrow);
$templater->register('navbar', $navbar);
$templater->register('pagetitle', $pagetitle);
print_output($templater->render());

?>

main template (only the main display of table)

<table align="center" border="1" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="100%">

<tr class="tcat">
<td class="smallfont" align=center width="120"><b>Date&nbsp;</b></td>
<td class="smallfont" align=center width="140"><b>Venue&nbsp;</b></td>
<td class="smallfont" align=center><b>Title&nbsp;</b></td>
<td class="smallfont" align=center width="40"><b>Age&nbsp;</b></td>
<td class="smallfont" align=center width="80"><b>Tickets&nbsp;</b></td>
</tr>
{vb:raw event_giglistrow}
</table>

templatebit that does the rows

<tr class="alt2">
<td class="smallfont" align=center>{vb:raw date}</td>
<td class="smallfont" align=center>{vb:raw venuename}</td>
<td class="smallfont" align=center>{vb:raw title}</td>
<td class="smallfont" align=center>{vb:raw age}</td>
<td class="smallfont" align=center>{vb:raw event_giglistrowticket}</td>
</tr>

third template for the ticket link

{vb:raw linkrow.ticketlink}

What seems to be happening is the ticket link is being skipped somehow then then just dropped in at the top of the gig list page.

It doesn't seem to be getting included in the template.