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, t3.ent_type, t4.cuisine_type, t5.music_type FROM est_overview AS t1, type_of_entertain as t3, type_of_cuisine as t4, type_of_music as t5 WHERE t1.publish = 'Y' AND t1.est_id = t3.est_id AND t3.ent_type = 'Wi-Fi ' AND t1.est_id = t4.est_id AND t4.cuisine_type = 'Subs' AND t1.est_id = t5.est_id AND t5.music_type = '80\'s ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30 80's Music Subs Food Wi-Fi in the Twin Cities | Twincitiesfun.com



80's Music Subs Food Wi-Fi in the Twin Cities

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

The Lodge
Of Robbinsdale

4080 W Broadway Ave, Suite 109 Robbinsdale, MN 55422
763-951-3943

Music: 80's  Country  DJ  Jukebox  Live Music  Oldies  Rock  Top 40 

Cuisine: American  Buffet  Italian  Mexican  Pizza  Salad Bar  Seafood  Soup  Steaks  Subs  Vegetarian 

Amenities Arcade Games  Bachelor/ette Party Specials  Banquet  Bar Bingo  Big Screen TV  Bingo  Birthday Parties  Brunch  Brunch Specials  Catering  Corporate Team Building  Dancing  Family Friendly  Featured Hotspots  Happy Hour  Jukebox  Karaoke  Kids Eat Free  Live Music  NFL Sunday Ticket  NHL Center Ice  Pull tabs  Receptions/wedding  Wi-Fi 

Travail Kitchen and Amusements

4154 West Broadway Robbinsdale, MN 55422
763-535-1131

Music: 80's  Country  Cuban  Eclectic  Indie Rock  Ipod  Jazz  Latin  Oldies  Reggae 

Cuisine: American  cafes  Catering  French  fresh Salad  Organic  Seafood  Soup  Steaks  Subs  Sushi  Take out  Tapas  Vegetarian 

Amenities Banquet  Bean Bag Tourney  Big Screen TV  Birthday Parties  Catering  Family Friendly  Featured Hotspots  Happy Hour  Receptions/wedding  Shuffle board  Take Out  TV  Wi-Fi 

Vannelli's By The Lake

55 S. Lake St Forest Lake, MN 55025
651-395-2400

Music: 80's  Country  DJ  House  Jukebox  Live Music  Rock  Top 40 

Cuisine: American  Italian  Mexican  Pizza  Salad Bar  Seafood  Soup  Steaks  Subs  Vegetarian 

Amenities Arcade Games  Bachelor/ette Party Specials  Banquet  Bar Bingo  Big Screen TV  Birthday Parties  Brunch  Brunch Specials  Catering  Darts  Family Friendly  Featured Hotspots  Happy Hour  Indoor Bocce Ball  Indoor Sports  Jukebox  Karaoke  Live Music  Outdoor/Patio  Progressive Bingo  Pull tabs  Receptions/wedding  Wi-Fi 

End Zone Bar & Grill

Closed Ramsey, MN 55303
763-433-2615

Music: 80's  Acoustic  Country  DJ  House  Jukebox  Live Music  Oldies  Rock  Top 40 

Cuisine: American  Pizza  Soup  Steaks  Subs  Vegetarian 

Amenities Arcade Games  Bar Bingo  Big Screen TV  Birthday Parties  College Football  Darts  DTV  Family Friendly  Featured Hotspots  Happy Hour  Jukebox  Ladies Night  Live Music  Outdoor/Patio  Progressive Bingo  Pull tabs  Texas Hold'em  Wi-Fi 

bamboo Betty's

3800 Restwood Rd. Circle pines, MN 55014
763-786-1014

Music: 80's  Classic Rock  Country  Cover Music  DJ  House  Live Music  Oldies  R&B  Rock  Satellite Radio  Top 40 

Cuisine: American  Pizza  Salad  Soup  Steaks  Subs  Take out 

Amenities Arcade Games  Bachelor/ette Party Specials  Big Screen TV  Brunch  Brunch Specials  Dancing  Darts  Family Friendly  Featured Hotspots  Garden Bar  Happy Hour  Karaoke  Ladies Night  Live DJ  Live Music  Progressive Bingo  Pull tabs  Satellite tv  Take Out  Texas Hold'em  Wi-Fi 


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