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 = 'Jukebox' AND t1.est_id = t4.est_id AND t4.cuisine_type = 'BBQ' 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 All Types Music BBQ Food Jukebox in the Twin Cities | Twincitiesfun.com



All Types Music BBQ Food Jukebox in the Twin Cities

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

TCFun
Discount!

DIVE Bar

3035 White Bear Avenue Maplewood, MN 55109
651-779-2266

Music: All Types  Bar Top 40  CD Player  Classic Rock  Country  Cover Music  Dinning Music  DJ  House  Jukebox  Live Concerts  Live Music  Pop  Rock  Top 40 

Cuisine: All Types  American  BBQ  BBQ Chicken Pizza  Breakfast  Buffet  Burgers  Chicken  Custom Menu Options  Hot Dogs  Italian  Meat  Other  Pasta  Pizza  Salad  Seafood  Snacks  Soup  Southern  Southern BBQ  Specialty Sandwhich  Steakhouse  Steaks  Subs  Take out  Wings 

Amenities 22 50' Plasma TV's  All You Can Eat  Bachelor/ette Party Specials  Bar Bingo  Big Screen TV  Breakfast  Breakfast Weekend  College Sport Team Specials  Dart Tournaments  Darts  Dine in / Take out  Family Friendly  Family Fun  Foam Parties  Full-Service Bar  Happy Hour  Hot Wait Staff  Jukebox  Karaoke  Live DJ  Live Music  Meetings  Outdoor Tiki Bar  Pool Tables  Pool Tournaments  Pull tabs  Restaurant Employee Night  Take Out  TV  Wi-Fi 

Flashback Cafe & Cocktail Lounge

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

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 

Amenities Arcade Games  Banquet  Big Screen TV  Bingo  Birthday Parties  Bowling  Bowling Leauges  Breakfast  Darts  DTV  Family Friendly  Happy Hour  Jukebox  Live Music  NFL Sunday Ticket  Outdoor/Patio  Pull tabs  Receptions/wedding  Take Out  Trivia  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