if ($query_result = mysql_query($query)) {
     $num_rows = mysql_num_rows($query_result);
     while ($table_row = mysql_fetch_row($query_result)) {
         $categoryID = $table_row[0];
         $eventName = $table_row[1];
         $eventTypeID = $table_row[2];
         $eventIntroText = $table_row[3];
         $eventText = $table_row[4];
         $eventImagePathname = $table_row[5];
     }
     if ($num_rows < 1) {
         header('HTTP/1.1 301 Moved Permanently');
         header('Location: http://www.mongotickets.com/');
         exit;
     }
     $keywords = BuildEventKeywordList($categoryID, $eventName, $eventTypeID, $id);
     $keywords = AmpersandToAnd($keywords);
     $smarty->assign("SeoKeywords", $keywords);
     $descr = "Buy {$eventName} Tickets at great prices. Discount {$eventName} tickets.";
     $url = make_event_url($eventName, $id);
     $breadcrumb_str = Breadcrumbs($categoryID, 0);
     $breadcrumb_str = AppendBreadcrumb($breadcrumb_str, "{$url}", $eventName);
     # if category is theater, list venues first.
     $disp_home_away = 0;
     if ($eventTypeID == 4) {
         $title = "{$eventName} Tickets, {$eventName} Schedule, {$eventName} Dates, Discounted {$eventName} Tickets";
         $smarty->assign("title", $title);
         $smarty->assign("MetaDescr", $descr);
         $smarty->display('main.tpl');
         $venues = GetVenueList($id);
         $smarty->assign("Breadcrumbs", $breadcrumb_str);
        $breadcrumb_str = AppendBreadcrumbNoAnchor($breadcrumb_str, "&nbsp;{$fullEventName} Tickets");
        $title = "{$eventName} Tickets at {$venueName} in {$city}, {$regionCode} on {$shortDate}";
        $heading1 = "{$eventName} Tickets";
    }
    $smarty->assign("MetaDescr", $meta_descr);
    mysql_close($dbh);
} else {
    header('HTTP/1.0 500 Internal Server Error');
    handle_error_no_exit('tickets.code: I cannot connect to the database because: ' . mysql_error() . ' production id= ' . $id . ' event id = ' . $eventID . ' uri= ' . $_SERVER['REQUEST_URI'] . ' returning 500');
    $error_message = get_error_message();
    $smarty->assign("ErrorMessage", $error_message);
    $smarty->display('main.tpl');
    $smarty->display('error_page.tpl');
}
$keywords = "";
$keywords = BuildEventKeywordList($fullEventName, $city);
$keywords = AmpersandToAnd($keywords);
$smarty->assign("SeoKeywords", $keywords);
$smarty->assign("title", $title);
$smarty->display('main.tpl');
$smarty->assign("Breadcrumbs", $breadcrumb_str);
$smarty->assign("EventName", $eventName);
$smarty->assign("Heading1", $heading1);
$smarty->assign("SubHeading", $subheading);
$smarty->assign("EventDate", $eventDate);
$smarty->assign("ShortDate", $shortDate);
$smarty->assign("EventID", $eventID);
$smarty->assign("VenueName", $venueName);
$smarty->assign("City", $city);
$smarty->assign("RegionCode", $regionCode);
$smarty->assign("VenueID", $venueID);