saveIntoErrorLog("DBConnection.php", "DBConnection()", "mysqli_connect()", mysqli_connect_error()); return false; } // Set charset for the connection mysqli_set_charset($connection, 'utf8'); $this->connection = $connection; $this->statement = true; // With mysqli_connect, database is selected automatically return true; /*} catch (Exception $e) { $this->saveIntoErrorLog("DBConnection.php", "DBConnection()", "", $e); return false; }*/ } function CloseConnection() { //try { $close = mysqli_close($this->connection); if(!$close) { $this->saveIntoErrorLog("DBConnection.php", "CloseConnection()", "mysqli_close()"); } return true; /*} catch (Exception $e) { $this->saveIntoErrorLog("DBConnection.php", "CloseConnection()", "", $e); return false; }*/ } /** * Execute query for select */ function SelectQuery($fileName="", $methodName="") { //try { if($this->connection && $this->statement) { if(empty($this->dbQuery)) { return false; } $this->dbResult = mysql_query($this->dbQuery, $this->connection); if(!$this->dbResult) { $this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery); return false; } $rowCount = 0; $resultData = array(); while($rowData = mysql_fetch_array($this->dbResult, MYSQL_ASSOC)) { $resultData[$rowCount] = $rowData; $rowCount++; } mysql_free_result($this->dbResult); return $resultData; } else { return false; } /*} catch (Exception $e) { $this->saveIntoErrorLog($fileName, $methodName, "", $e); return false; }*/ } /** * Execute query for Insert */ function InsertQuery($fileName="", $methodName="") { //try { if($this->connection && $this->statement) { if(empty($this->dbQuery)) { return false; } $this->dbResult = mysql_query($this->dbQuery, $this->connection); if(!$this->dbResult) { $this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery); return false; } $id = mysql_insert_id(); mysql_free_result($this->dbResult); return $id; } else { return false; } /*} catch (Exception $e) { $this->saveIntoErrorLog($fileName, $methodName, "", $e); return false; }*/ } /** * Execute query for Update/Delete */ function ExecuteQuery($fileName="", $methodName="") { //try { if($this->connection && $this->statement) { if(empty($this->dbQuery)) { return false; } $this->dbResult = mysqli_query($this->connection, $this->dbQuery); if(!$this->dbResult) { $this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery); return false; } $rows = 0; $rows = mysqli_affected_rows($this->connection); mysqli_free_result($this->dbResult); return $rows; } else { return false; } /*} catch (Exception $e) { $this->saveIntoErrorLog($fileName, $methodName, "", $e); return false; }*/ } /** * Execute queries for webservice */ function SelectQueryResult($fileName="", $methodName="") { //try { if($this->connection && $this->statement) { if(empty($this->dbQuery)) { return false; } $this->dbResult = mysql_query($this->dbQuery, $this->connection); if(!$this->dbResult) { $this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery); return false; } $resultData = $this->dbResult; //mysql_free_result($this->dbResult); return $resultData; } else { return false; } /*} catch (Exception $e) { $this->saveIntoErrorLog($fileName, $methodName, "", $e); return false; }*/ } /** * Use this method to log the database errors. */ function saveIntoErrorLog($fileName="", $methodName="", $sqlQuery="", $exception="") { $errorCode = mysql_errno(); $errorText = mysql_error(); $errorMessage = "File: ".$fileName.", Method/Function: ".$methodName.", Query: ".$sqlQuery.", Error: ".$errorCode."-".$errorText; if($exception != "") $errorMessage.= " Exception : ".$exception ; // timestamp for the error entry $errorMessage = "[".date("j-M-Y H:i:s (T)")."] ".$errorMessage."\r\n"; // save to the error log error_log($errorMessage, 3, ERROR_LOG."ErrorLog".date("j-M-Y").".log"); } } //ends the class over here ?> SELECT t1.est_id, t1.icon, t1.est_name, t1.est_street, t1.est_city, t1.est_state, t1.est_zip, t1.est_phone, t1.accnt_type, t1.percentoffcard, t2.est_type, t3.ent_type, t5.music_type FROM est_overview AS t1, type_of_est as t2, type_of_entertain as t3, type_of_music as t5 WHERE t1.publish = 'Y' AND t1.est_id = t2.est_id AND t2.est_type = 'Reservations Accepted ' AND t1.est_id = t3.est_id AND t3.ent_type = 'NFL Sunday Ticket ' AND t1.est_id = t5.est_id AND t5.music_type = 'Alternative' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30 Reservations Accepted Alternative Music with NFL Sunday Ticket in the Twin Cities | Twincitiesfun.com



Reservations Accepted Alternative Music with NFL Sunday Ticket in the Twin Cities

2 Results, Scroll down to view
Search Options
+More Map
Sort: Featured | Name | City
1 - 2 of 2 Results

Champps

1734 N Adolphus Street Maplewood, MN 55117
651-487-5050

Place to Go: Bars/Nightclubs  Catering  Outdoor/Patio  Receptions/Weddings  Reservations Accepted  Restaurants  Sports Bars  Take Out  WiFi Hotspots 

Music: Alternative  Jukebox  Rock  Top 40 

Amenities Arcade Games  Bachelor/ette Party Specials  Banquet  Bar Bingo  Big Screen TV  Birthday Parties  Breakfast Weekend  Brunch  Brunch Specials  Catering  College Football  Darts  Family Friendly  Happy Hour  Jukebox  Kids Eat Free  NBA League Pass  NFL Sunday Ticket  NHL Center Ice  Outdoor/Patio  Progressive Bingo  Pull tabs  Receptions/wedding  Texas Hold'em  Trivia  UFC 

Mounds Park Sports Bar

1067 Hudson Rd St. Paul, MN 55106
651-340-0319

Place to Go: 21+ Clubs  Bands  Bar Crawl  Bars/Nightclubs  Bingo service  Family Fun  Fun  Golf  Mobile Video Game Entertainment Center  Music Venue  Nightclub  Party Promoter  Receptions/Weddings  Reservations Accepted  Service  Social Club  Sports Bars  WiFi Hotspots  Wine Bar 

Music: 80's  All Types  Alternative  Big Band/Swing  Classic Rock  Country  Cover Music  Custom Blend  Hip Hop  Jukebox  Live Concerts  Live Music  Mix  Oldies  Piano  Pop  R&B  Reggae  Rock  Salsa  Varies 

Amenities 22 50' Plasma TV's  Arcade Games  Bachelor/ette Party Specials  Bands  Bar Bingo  Baseball  Big Screen TV  Bingo  Birthday Parties  Bowling  Cards  College Sport Team Specials  Dancing  Dart Tournaments  Featured Hotspots  Free Computer access  Full-Service Bar  Gift Cards  GLBT Friendly  Happy Hour  Indoor Sports  Jukebox  Karaoke  Live Music  Meat Raffle  Meetings  NFL Sunday Ticket  Private Party   Progressive Bingo  Promotional Items  Pull tabs  Receptions/wedding  Reservations Accepted  Texas Hold'em  TV  Wi-Fi 


1 - 2 of 2 Results
*All information is deemed reliable, but unfortunatly cannot not be guaranteed. Events & prices are subject to change.
Popular Searches

Minneapolis Happy Hour

Minneapolis Restaurants

Lunch Specials at Restaurants in St. Paul

Bars/Nightclubs with Indoor Sports

Drink Specials in Mpls