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, t4.cuisine_type FROM est_overview AS t1, type_of_est as t2, type_of_entertain as t3, type_of_cuisine as t4 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 t1.est_id = t4.est_id AND t4.cuisine_type = 'Mediterranean' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30 Restaurants Mediterranean Food with Happy Hour in the Twin Cities | Twincitiesfun.com



Restaurants Mediterranean Food with Happy Hour in the Twin Cities

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

La Chaya Bistro

4537 Nicollet Ave S. Minneapolis, MN 55419
612-827-2254

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

Cuisine: Italian  Mediterranean  Mexican  Organic  Pizza  Seafood  Steaks  Vegetarian 

Amenities Birthday Parties  Brunch  Brunch Specials  Catering  Family Friendly  Happy Hour  Outdoor/Patio  Receptions/wedding 

Mediterranean Cruise Cafe

12500 Nicollet Ave Burnsville, MN 55337
952-641-6222

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

Cuisine: Buffet  Catering  Fish  Mediterranean  Middle Eastern  Pasta  Seafood  Steaks  Take out  Vegetarian 

Amenities Banquet  Belly Dancing  Big Screen TV  Birthday Parties  Catering  Children's Menu  Dancing  Family Friendly  Featured Hotspots  Happy Hour  Hookah  Kids Eat Free  Live DJ  Outdoor/Patio  Pull tabs  Receptions/wedding  Reservations Accepted  Shisha   Take Out  Wi-Fi 

Running Aces Harness Park and Card Room

15201 Zurich ST. NE Columbus, MN 55025
651-925-4600

Place to Go: 18+ Clubs  21+ Clubs  Bars/Nightclubs  Cafés  Casino  Deli  Fast Food  Fun  Harness Racing  Horse Racing  Outdoor/Patio  Pizza  Receptions/Weddings  Reservations Accepted  Restaurants  Sports Bars  Weekend Breakfast/Brunch 

Cuisine: All Types  American  Buffet  Chinese  Mediterranean  Pizza  Salad  Seafood  Soup  Steaks  Subs  Vegetarian 

Amenities Arcade Games  Banquet  Big Screen TV  Birthday Parties  Brunch  Brunch Specials  Casino  Family Friendly  Gambling  Happy Hour  Harness Racing  Horse Racing  Live Music  Outdoor/Patio  Receptions/wedding  Stand Up 

Running Aces Winners Circle Restaurant & Lounge

15201 Zurich ST. NE Columbus, MN 55025
651-928-4600

Place to Go: 18+ Clubs  21+ Clubs  Bars/Nightclubs  Casino  Deli  Fast Food  Fun  Harness Racing  Horse Racing  Outdoor/Patio  Pizza  Receptions/Weddings  Reservations Accepted  Restaurants  Sports Bars  Weekend Breakfast/Brunch 

Cuisine: All Types  American  Buffet  Chinese  Mediterranean  Pizza  Salad  Seafood  Soup  Steaks  Subs  Vegetarian 

Amenities Arcade Games  Banquet  Big Screen TV  Birthday Parties  Brunch  Brunch Specials  Casino  Family Friendly  Gambling  Happy Hour  Harness Racing  Horse Racing  Live Music  Outdoor/Patio  Receptions/wedding  Stand Up 

Sgt. Peppers Grille & Bar

930 Helena Ave. N. Oakdale, MN 55128
651-738-7052

Place to Go: Arcades  Bars/Nightclubs  Catering  Outdoor/Patio  Reservations Accepted  Restaurants  Sports Bars  Take Out  Weekend Breakfast/Brunch  WiFi Hotspots 

Cuisine: American  BBQ  Burgers  Catering  Chicken  Fish  fresh Salad  Italian  Mediterranean  Mexican  Seafood  Soup  Steaks  Take out  Vegetarian  Weekend Breakfast  Wings 

Amenities Arcade Games  Ballon lady (kids)  Banquet  Bar Bingo  Big Screen TV  Bingo  Birthday Parties  Breakfast  Breakfast Weekend  Brunch Specials  Darts  DTV  Family Friendly  Family Fun  Gift Cards  Happy Hour  Jukebox  Karaoke  Live Music  Meeting Room  Outdoor/Patio  Private Party   Pull tabs  Reservations Accepted  Take Out  Trivia  Wi-Fi 

Yafa Grille and Pizzeria/Hooka Paradise

4110 Central Ave. NE Columbia Heights, MN 55421
763-789-9232

Place to Go: Catering  Hookah Lounge  Pizza  Receptions/Weddings  Reservations Accepted  Restaurants  Take Out  WiFi Hotspots 

Cuisine: American  Greek  Mediterranean  Middle Eastern  Pizza  Vegetarian 

Amenities Birthday Parties  Catering  Family Friendly  Happy Hour  Hookah  Receptions/wedding  Soccer  Wi-Fi 


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