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, " {$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);