$host = "localhost";
$username = "adminfs";
$password = "thefishdb373PV";
$database = "fishingshop";
$db=mysql_connect($host,$username,$password);
mysql_select_db($database,$db);
$merchant_product_id = $_REQUEST["id"];
$sql = "select * from fistec where merchant_product_id = '" . $merchant_product_id . "'";
$result = mysql_query($sql);
$productrow = mysql_fetch_array($result);
$titles[1] = "Carp Fishing Tackle";
$titles[2] = "Fly Fishing Tackle";
$titles[3] = "Course Fishing Tackle";
$titles[4] = "Spinning Tackle";
$titles[5] = "Sea Fishing Tackle";
$keywords[1] = "shimano, carp, rods, carp rigs, bollies";
$keywords[2] = "";
$keywords[3] = "tackle box, fishing rods, fishing equipment, coarse fishing tackle, telescopic fishing rod";
$keywords[4] = "";
$keywords[5] = "sea fishing tackle, online sea fishing, sea fishing gear, sea rods";
$kdescription[1] = "Carp fishing tackle from UK fishing tackle shops.";
$kdescription[2] = "";
$kdescription[3] = "Coarse/Match fishing tackle from fishing shops in the UK.";
$kdescription[4] = "";
$kdescription[5] = "Sea fishing gear from FishingShop.co.uk";
$links[1] = "CarpTackle";
$links[2] = "FlyTackle";
$links[3] = "MatchFishing";
$links[4] = "SpinningTackle";
$links[5] = "SeaFishingTackle";
?>
echo $productrow["product_name"]; ?> | echo $productrow["merchant_category"]; ?> | echo $titles[$productrow["cat"]]; ?>
" />
, , fishing shop, , " />