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



Connecting to MySQL server: p3plzcpnl506558.prod.phx3.secureserver.net with user: twincitiesfun
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 = 'Sports Bars' AND t1.est_id = t3.est_id AND t3.ent_type = 'Wi-Fi' AND substring(t1.est_name,1,1) = 't ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30Query: 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 = 'Sports Bars' AND t1.est_id = t3.est_id AND t3.ent_type = 'Wi-Fi' AND substring(t1.est_name,1,1) = 't ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30
Query: 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 = 'Sports Bars' AND t1.est_id = t3.est_id AND t3.ent_type = 'Wi-Fi' AND substring(t1.est_name,1,1) = 't ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC
Query: SELECT date_format(date2, '%Y-%c-%e') as ArticleDate FROM featured_events
Query: SELECT eo.est_id, est_name, est_city, icon FROM est_overview as eo, type_of_est as toe WHERE eo.est_id = toe.est_id AND toe.est_type = 'Restaurants' AND eo.accnt_type = 'P' AND publish = 'Y' ORDER BY RAND() LIMIT 3
Query: SELECT eo.est_id, title, `description`, est_name, est_city FROM perks as p, est_overview as eo WHERE eo.est_id = p.est_id AND eo.publish = 'Y' ORDER BY RAND() LIMIT 3
Query: SELECT est_type, count(*) AS Count FROM type_of_est as toe, est_overview as eo WHERE eo.est_id = toe.est_id AND eo.accnt_type = 'P' GROUP BY toe.est_type ORDER BY Count DESC LIMIT 8
Query: SELECT ent_type, count(*) AS Count FROM type_of_entertain as toe, est_overview as eo WHERE eo.est_id = toe.est_id AND eo.accnt_type = 'P' GROUP BY toe.ent_type ORDER BY Count DESC LIMIT 8
Query: SELECT cuisine_type, count(*) AS Count FROM type_of_cuisine as toc, est_overview as eo WHERE eo.est_id = toc.est_id AND eo.accnt_type = 'P' GROUP BY toc.cuisine_type ORDER BY Count DESC LIMIT 8
Query: SELECT music_type, count(*) AS Count FROM type_of_music as tom, est_overview as eo WHERE eo.est_id = tom.est_id AND eo.accnt_type = 'P' GROUP BY tom.music_type ORDER BY Count DESC LIMIT 8
Query: SELECT perks_type, count(*) AS Count FROM type_of_perks as top, est_overview as eo WHERE eo.est_id = top.est_id AND eo.accnt_type = 'P' GROUP BY top.perks_type ORDER BY Count DESC LIMIT 8
Query: SELECT est_city, count(*) AS Count FROM est_overview as eo WHERE eo.accnt_type = 'P' GROUP BY eo.est_city ORDER BY Count DESC LIMIT 8
Query: SELECT event_type, count(*) AS Count FROM daily_events as de, est_overview as eo WHERE eo.est_id = de.est_id GROUP BY de.event_type ORDER BY Count DESC LIMIT 9
Query: SELECT dotw, dotw_num, count(*) AS Count FROM daily_events as de, est_overview as eo WHERE eo.est_id = de.est_id GROUP BY de.dotw, de.dotw_num ORDER BY dotw_num ASC LIMIT 7
Sports Bars with Wi-Fi in the Twin Cities | Twincitiesfun.com



Sports Bars with 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
Query: SELECT title FROM perks WHERE est_id = '003723'

The Dog House Bar and Grill

2029 Windlynn Ave Maplewood, MN 55109
651-621-1535
Query: SELECT * FROM gift_cards WHERE est_id = 3723 AND publish = '1'
Query: SELECT te.est_type FROM type_of_est as te WHERE te.est_id = '003723' ORDER BY est_type

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

Query: SELECT te.ent_type FROM type_of_entertain as te WHERE te.est_id = '003723' ORDER BY ent_type

Amenities Arcade Games  Bar Bingo  Big Screen TV  Birthday Parties  Darts  Family Friendly  Happy Hour  Jukebox  Karaoke  Ladies Night  Live Music  Open Mic/Amateur Night  Outdoor/Patio  Pool Tables  Progressive Bingo  Restaurant Employee Hospitality Specials  Tri-wheel®  Wi-Fi 

Query: SELECT title FROM perks WHERE est_id = '003583'

The Lodge
Of Robbinsdale

4080 W Broadway Ave, Suite 109 Robbinsdale, MN 55422
763-951-3943
Query: SELECT * FROM gift_cards WHERE est_id = 3583 AND publish = '1'
Query: SELECT te.est_type FROM type_of_est as te WHERE te.est_id = '003583' ORDER BY est_type

Place to Go: Bars/Nightclubs  Breakfest  Catering  Delivery  Pizza  Receptions/Weddings  Reservations Accepted  Restaurants  Sports Bars  Take Out  WiFi Hotspots 

Query: SELECT te.ent_type FROM type_of_entertain as te WHERE te.est_id = '003583' ORDER BY ent_type

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 

Query: SELECT title FROM perks WHERE est_id = '003676'

Tin Cup Restaurant & Bar

1220 Rice St. St. Paul, MN 55117
651-487-7967
Query: SELECT * FROM gift_cards WHERE est_id = 3676 AND publish = '1'
Query: SELECT te.est_type FROM type_of_est as te WHERE te.est_id = '003676' ORDER BY est_type

Place to Go: Bars/Nightclubs  Pizza  Reservations Accepted  Restaurants  Sports Bars  Take Out  WiFi Hotspots 

Query: SELECT te.ent_type FROM type_of_entertain as te WHERE te.est_id = '003676' ORDER BY ent_type

Amenities Banquet  Bar Bingo  Big Screen TV  Birthday Parties  Breakfast  Family Friendly  Happy Hour  Jukebox  Karaoke  Live Music  Progressive Bingo  Pull tabs  Texas Hold'em  Trivia  Wi-Fi 

Query: SELECT title FROM perks WHERE est_id = '003588'

Travail Kitchen and Amusements

4154 West Broadway Robbinsdale, MN 55422
763-535-1131
Query: SELECT * FROM gift_cards WHERE est_id = 3588 AND publish = '1'
Query: SELECT te.est_type FROM type_of_est as te WHERE te.est_id = '003588' ORDER BY est_type

Place to Go: Bars/Nightclubs  Cafés  Receptions/Weddings  Restaurants  Sports Bars  Take Out  WiFi Hotspots  Wine Bar 

Query: SELECT te.ent_type FROM type_of_entertain as te WHERE te.est_id = '003588' ORDER BY ent_type

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 

Totino's Italian Kitchen

Closed Mounds view, MN 55112
763-780-0712
Query: SELECT * FROM gift_cards WHERE est_id = 3389 AND publish = '1'
Query: SELECT te.est_type FROM type_of_est as te WHERE te.est_id = '003389' ORDER BY est_type

Place to Go: Bars/Nightclubs  Catering  Nightclub  Pizza  Restaurants  Sports Bars 

Query: SELECT te.ent_type FROM type_of_entertain as te WHERE te.est_id = '003389' ORDER BY ent_type

Amenities Family Friendly  Kids Eat Free  NFL Sunday Ticket  Receptions/wedding  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