Naval Ties: Royal Navy & Merchant Navy Ties
Collectors Centre Online
35, St.Nicholas Cliff, Scarborough
North Yorkshire YO11 2ES (UK)
Naval Ties: Royal Navy, Merchant Navy, Marines & Commando Ties
We stock a range of Merchant Navy, Royal Navy, Marines and Commandos ties in our very popular polyester and silk ties.
Manufactured in the UK, our selection of silk ties and polyester ties are high quality and great for functions, parades and general day wear.
Please use at least 3 letters in a search");
$PrdSearch = NULL;
}
$PrdSearchAll = ($_POST['showAll']);
if ($PrdSearch != NULL)
{
$SrchQuery = "SELECT * from $TableName, $TableName2 WHERE ($TableName.Prod_Cat = 'Naval Ties') AND $TableName.Prod_Stock_Lvl >= '0' AND (Prod_Name LIKE '%$PrdSearch%' OR Prod_Sh_Desc LIKE '%$PrdSearch%' OR Prod_Ln_Desc LIKE '%$PrdSearch%' ) AND $TableName.Prod_Img = $TableName2.Img_Id ORDER BY $TableName.Prod_Name";
$ProdFlag = TRUE;
}
elseif($PrdSearchAll != NULL)
{
$SrchQuery = "SELECT * from $TableName, $TableName2 WHERE ($TableName.Prod_Cat = 'Naval Ties') AND $TableName.Prod_Stock_Lvl >= '0' AND $TableName.Prod_Img = $TableName2.Img_Id ORDER BY 'Prod_Name' ";
$ProdFlag = TRUE;
}
else
{
print("Please enter a word or part of a word in the search boxes");
}
}
else
{
$Query = "SELECT * from $TableName, $TableName2 WHERE ($TableName.Prod_Cat = 'Naval Ties') AND $TableName.Prod_Stock_Lvl >= '0' AND $TableName.Prod_Img = $TableName2.Img_Id ORDER BY 'Prod_Name' ";
}
if($ProdFlag == true)
{
$Result = mysql_db_query ($DBName, $SrchQuery, $Link);
}
else
{
$Result = mysql_db_query ($DBName, $Query, $Link);
}
// Fetch the results from the database.
while ($Row = mysql_fetch_array ($Result,MYSQL_BOTH))
{
$Num = mysql_num_rows($Result);
$ProdNum = ("$Row[Prod_Id]");
$ProdSCat = ("$Row[Prod_Super_Cat]");
$ProdCat = ("$Row[Prod_Cat]");
$ProdSubCat = ("$Row[Prod_Sub_Cat]");
$ProdName = ("$Row[Prod_Name]");
$ProdBrd = ("$Row[Prod_Brand]");
$ProdPrc = ("$Row[Prod_Price]");
$ProdCode = ("$Row[Prod_Code]");
$ProdPkQty = ("$Row[Prod_Pack_Qty]");
$ProdSDesc = ("$Row[Prod_Sh_Desc]");
$ProdLDesc = ("$Row[Prod_Ln_Desc]");
$ProdSLvl = ("$Row[Prod_Stock_Lvl]");
$ProdWid = ("$Row[Prod_Width]");
$ProdHgt = ("$Row[Prod_Height]");
$ProdDpt = ("$Row[Prod_Depth]");
$ProdClr = ("$Row[Prod_Colour]");
$ProdImg = ("$Row[Prod_Img]");
$ImgUrl = ("$Row[Img_Url]");
$ImgAlt = ("$Row[Img_Alt]");
$ImgW = ("$Row[Img_Width]");
$ImgH = ("$Row[Img_Height]");
if($ProdSLvl > 0) //check if in stock - show relevant form
{
include('../code/display-form.php');
}
else
{
include('../code/display-form-os.php');
}
}
mysql_close ($Link);
?>
Naval Ties, Bow-ties and Cravats in Polyester and Silk.
Results Displayed:
* All UK orders just £2.25 P&P - Great Value (automatically added at checkout).
Worldwide Carriage/Postage £6.25 - Outside UK and Over £10, please click below to add the additional carriage charge to your order
Shop and Buy Online, use a Printable Order Form, use our Contact Us Form. or Phone 01723 365221
Collectors Centre Online, 35 St.Nicholas Cliff, Scarborough, North Yorks, YO11 2ES