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 FROM est_overview AS t1, type_of_est as t2, type_of_entertain as t3 WHERE t1.publish = 'Y' AND t1.est_id = t2.est_id AND t2.est_type = 'Restaurants' AND t1.est_id = t3.est_id AND t3.ent_type = 'Happy Hour' AND substring(t1.est_name,1,1) = 'b ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30 Restaurants with Happy Hour in the Twin Cities | Twincitiesfun.com



Restaurants with Happy Hour in the Twin Cities

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

Big Louie's Bar & Grill

790 County Rd D New Brighton, MN 55112
651-636-2901

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

Amenities Arcade Games  Bar Bingo  Big Screen TV  Brunch Specials  Catering  Darts  Easter & Mothers Day Brunch  Family Friendly  Happy Hour  Karaoke  Kids Eat Free  Meat Raffle  Outdoor/Patio  Progressive Bingo  Pull tabs  Receptions/wedding  Restaurant Employee Hospitality Specials  Tri-wheel®  Wi-Fi 

Big Louie's Bar & Grill

5216 West Broadway Crystal, MN 55429
763-533-2977

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

Amenities Arcade Games  Banquet  Big Screen TV  Bingo  Birthday Parties  Brunch Specials  Darts  Family Friendly  Featured Hotspots  Happy Hour  Indoor Sports  Jukebox  Karaoke  Kids Eat Free  Outdoor/Patio  Pool Tables  Pull tabs  Receptions/wedding  Restaurant Employee Hospitality Specials  Trivia  Wi-Fi 

Billy's on Grand

857 Grand Avenue St. Paul, MN 55105
651-292-9140

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

Amenities Arcade Games  Banquet  Big Screen TV  Birthday Parties  Darts  Family Friendly  Featured Hotspots  Happy Hour  Jukebox  NFL Sunday Ticket  Outdoor/Patio  Pool Tables  Receptions/wedding  Restaurant Employee Night  Trivia  Wi-Fi 


TCFun
Discount!

Birdhouse on Hennepin

2516 Hennepin Ave S Minneapolis, MN
612-377-2213

Place to Go: Bars/Nightclubs  Breakfast  Cafés  Outdoor/Patio  Restaurants  Take Out 

Amenities Breakfast  Happy Hour  Outdoor/Patio  Take Out  Wi-Fi 

Black Dog Coffee and Wine Bar

308 Prince Street Suite 100 St. Paul, MN 55101
651-228-9274

Place to Go: Bars/Nightclubs  Cafés  Coffee/Tea Houses  Nightclub  Outdoor/Patio  Pizza  Restaurants  Take Out  WiFi Hotspots 

Amenities Catering  Happy Hour  Live Music  Outdoor/Patio  Receptions/wedding  Wi-Fi 

Blue Door Pub

1811 Selby Ave. St. Paul, MN 55104
651-493-1865

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

Amenities Arcade Games  Big Screen TV  Birthday Parties  Family Friendly  Featured Hotspots  Happy Hour  Outdoor/Patio  Wi-Fi 

bamboo Betty's

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

Place to Go: Bars/Nightclubs  Music Venue  Nightclub  Outdoor/Patio  Restaurants  Sports Bars  Take Out  WiFi Hotspots 

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