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, t4.cuisine_type, t5.music_type FROM est_overview AS t1, type_of_est as t2, type_of_cuisine as t4, 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 = t4.est_id AND t4.cuisine_type = 'Pizza' AND t1.est_id = t5.est_id AND t5.music_type = 'All Types ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30 Outdoor/Patio All Types Music Pizza Food in the Twin Cities | Twincitiesfun.com



Outdoor/Patio All Types Music Pizza Food in the Twin Cities

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

Bogart's Nightclub / Apple Place Lanes

14917 Garrett Avenue S Apple Valley, MN 55124
952-432-1515

Place to Go: 21+ Clubs  Arcades  Bars/Nightclubs  Bowling Alleys  Nightclub  Outdoor/Patio  Pizza  Restaurants  Sports Bars  Take Out 

Music: 80's  All Types  Bar Top 40  Hip Hop  Live Music  R&B  Rock 

Cuisine: American  fresh Salad  Pizza  Subs 


TCFun
Discount!

Burnsville Ale House

3809 Highway 13 W. Burnsville, MN 55337
952-882-2911

Place to Go: Bands  Fun  Music Venue  Outdoor/Patio  Pizza  Take Out  WiFi Hotspots 

Music: 80's  All Types  Bar Top 40  Blues  Classic Rock  Cover Music  Jazz  Jukebox  Live Concerts  Oldies  Pop  R&B  Rock  Top 40 

Cuisine: All Deitary Needs  American  Asian  Burgers  Dessert Menu  Fish  fresh Salad  Grill  Homemade Pastry  Jamaican  Kids Menu  Meat  Mexican  MSG Free  Pizza  Salad  Seafood  Soul Food  Southwestern  Specialty Sandwhich  Take out  Vegetarian  Wings 

Flashback Cafe & Cocktail Lounge

2520 26th Ave S. Minneapolis, MN 55406
612-721-6211

Place to Go: Arcades  Bars/Nightclubs  Bowling Alleys  GLBT Venues  Nightclub  Outdoor/Patio  Pizza  Restaurants  Sports Bars  Take Out 

Music: All Types  Jukebox  Live Music  Satellite Radio 

Cuisine: American  BBQ  Breakfast  Burgers  Chicken  Fish  fresh Salad  Hot Dogs  Italian  Mexican  Pasta  Pizza  Salad  Soup  Steaks  Take out  Vegetarian  Weekend Breakfast 

Hydrant, The

124 Main Bethel, MN 55055
763-434-5226

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

Music: 80's  All Types  Alternative  Bar Top 40  Classic Rock  Country  Indie Rock  Jukebox  Live Music  Rock 

Cuisine: Pizza 

Memory Lanes
Flashback Cafe and Cocktail lounge

2520 26th Ave S. Minneapolis, MN 55406
612-721-6211

Place to Go: Arcades  Bars/Nightclubs  Bowling Alleys  Breakfast  Fun  Music Venue  Nightclub  Outdoor/Patio  Pizza  Reservations Accepted  Restaurants  Sports Bars  Take Out  Winter Destinations 

Music: All Types  Jukebox  Live Music  Satellite Radio 

Cuisine: American  Breakfast  Burgers  Chicken  Fish  Hot Dogs  Italian  Pasta  Pizza  Salad  Soup  Steaks  Vegetarian 

Rail Station Bar and Grill

3675 Minnehaha Ave S Minneapolis, MN 55406
612-729-3663

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

Music: All Types 

Cuisine: American  Mexican  Pizza  Seafood  Soup  Steaks  Take out  Vegetarian 

Casey's Bar and Grille

Closed Minneapolis, MN 55408
612-825-3229

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

Music: All Types  Bar Top 40  Blues  Classic Rock  Country  House  Jukebox  Live Music  Rock 

Cuisine: American  Fish  Pizza 


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