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 = 'Outdoor/Patio ' AND t1.est_id = t3.est_id AND t3.ent_type = 'Trivia ' AND t1.est_id = t5.est_id AND t5.music_type = 'Rock' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30 Outdoor/Patio Rock Music with Trivia in the Twin Cities | Twincitiesfun.com



Outdoor/Patio Rock Music with Trivia in the Twin Cities

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

Blarney Pub & Grill

412 14th Ave. S.E. Minneapolis, MN 55414
612-331-1527

Place to Go: Bars/Nightclubs  Nightclub  Outdoor/Patio  Restaurants  Sports Bars  Take Out 

Music: Acoustic  Country  Rock 

Amenities Arcade Games  Brunch  Darts  Family Friendly  Guys Night  Jukebox  Karaoke  Ladies Night  Live Music  Outdoor/Patio  Reservations Accepted  Trivia 

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 

Eagles 34

2507 E. 25th St. Minneapolis, MN 55406
612-724-9714

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

Music: Blues  Cajun Music  Country  Dinning Music  Jazz  Live Music  Rock 

Amenities Banquet  Bar Bingo  Big Screen TV  Bingo  Birthday Parties  Brunch  Catering  Dancing  Dart Tournaments  Darts  Family Friendly  Full-Service Bar  Happy Hour  Karaoke  Meeting Room  Meetings  Outdoor/Patio  Private Party   Progressive Bango  Pull tabs  Receptions/wedding  Take Out  Trivia  Wi-Fi 

Loring Kitchen and Bar

1359 Willow St. S. Minneapolis, MN 55403
612-843-0400

Place to Go: Bars/Nightclubs  Breakfast  Cafés  Catering  Delivery  Fine Dining  Martini Bar  Outdoor/Patio  Receptions/Weddings  Reservations Accepted  Restaurants  Sports Bars  Take Out  Weekend Breakfast/Brunch  WiFi Hotspots 

Music: 80's  Alternative  Blues  DJ  Eclectic  Jazz  Latin  Live Music  Piano  R&B  Reggae  Rock  Salsa 

Amenities Banquet  Big Screen TV  Birthday Parties  Brunch  Brunch Specials  Catering  Featured Hotspots  Happy Hour  Karaoke  Live Music  Outdoor/Patio  Receptions/wedding  Satellite TV  Trivia  Wi-Fi 

Nomad World Pub

501 Cedar Avenue S (at Riverside) Minneapolis, MN 55454
612-338-6424

Place to Go: 21+ Clubs  Bars/Nightclubs  Nightclub  Outdoor/Patio 

Music: Acoustic  DJ  Folk  Indie Rock  Live Music  Reggae  Rock 

Amenities Big Screen TV  Bocce Ball Courts  Live DJ  Live Music  Outdoor/Patio  Pool Tables  Soccer  Trivia  Wi-Fi 

Well Sports Tavern & Grill

35 Coon Rapids Blvd. Coon Rapids, MN 55448
763-792-0800

Place to Go: Bars/Nightclubs  Breakfast  Outdoor/Patio  Pizza  Restaurants  Sports Bars  Take Out  WiFi Hotspots 

Music: Country  Jukebox  Rock 

Amenities Arcade Games  Big Screen TV  Birthday Parties  Cribbage  Darts  Drunken Horseshoes  DTV  Happy Hour  Jukebox  Karaoke  Meat Raffle  Outdoor/Patio  Pull tabs  Trivia  Wi-Fi 

Saba's Sports Bar & Grill

Closed Shakopee, MN 55379
952-496-9044

Place to Go: 21+ Clubs  Bars/Nightclubs  Billiards/Pool Halls  Nightclub  Outdoor/Patio  Restaurants  Sports Bars 

Music: DJ  Hip Hop  Jukebox  Latin  Mexican  R&B  Rap  Rock  Salsa 

Amenities Arcade Games  Big Screen TV  Dancing  Darts  Family Friendly  Ladies Night  NFL Sunday Ticket  Outdoor/Patio  Pool Tables  Soccer  Trivia 


1 - 7 of 7 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