Collections

Victoria Cross Medal, Collections

Victoria Cross Medal

The Victoria Cross (VC) is the highest military decoration awarded for valour "in the face of the enemy" to members of British, Commonwealth and Empire armed forces. The Lancashire Fusiliers have been awarded nineteen VCs, eighteen of which were awarded in the First World War, more than any other regiment in that conflict. The Fusilier Museum holds seven VCs as part of its medal collection, including two of the six awarded "before breakfast" to the 1st Battalion at Gallipoli in 1915.

You may also be interested in

'0' OR p.stockaction = 'show') GROUP BY p.productid ORDER BY p.name LIMIT " . $related_products . ""; $result_related = $db->query($sql_related); $col = 1; while ($row_related = $result_related->fetch()) { $sql_category = "SELECT c.parent AS parent1, c2.parent AS parent2 FROM productcategories pc JOIN categories c ON pc.categoryid = c.categoryid LEFT JOIN categories c2 ON c2.categoryid = c.parent WHERE pc.productid = '" . mysql_real_escape_string($row_related['productid']) . "'"; $result_category = $db->query($sql_category); $row_category = $result_category->fetch(); if ($row_category['parent2'] == 0) { $parents = $row_category['parent1'] . '/'; } else { $parents = $row_category['parent1'] . '/' . $row_category['parent2'] . '/'; } $sql_image = "SELECT pi.filename FROM productimages pi WHERE pi.productid = '" . mysql_real_escape_string($row_related['productid']) . "' ORDER BY pi.order LIMIT 1"; $result_image = $db->query($sql_image); if ($result_image->size() == 0) { $filename = 'no_image.jpg'; } else { $row_image = $result_image->fetch(); $filename = $row_image['filename']; } $sql_prices = "SELECT *, r.fldPrice AS reducedTo FROM stock s LEFT JOIN ( SELECT * FROM reductions WHERE ( fldDateStart IS NULL OR fldDateStart <= NOW() ) AND ( fldDateEnd IS NULL OR fldDateEnd >= NOW() ) ) AS r ON r.fldProductID = s.productid WHERE s.productid = '" . mysql_real_escape_string($row_related['productid']) . "' AND s.status = 'live' ORDER BY s.price"; $result_prices = $db->query($sql_prices); $row_prices = $result_prices->fetch(); $price = $row_prices['price']; $reducedPrice = $row_prices['reducedTo']; // Figure out image size for markup $tmpImagePath = 'http://'.$serverName.'/product_images/image_resize.php?image='.urlencode($filename).'&max_width=85&max_height=125'; $tmpImageData = getimagesize($tmpImagePath); if(is_null($reducedPrice)) $priceDisplay = '£'.number_format(round($price,2),2); else $priceDisplay = 'was £'.number_format(round($price,2),2).'
now £'.number_format(round($reducedPrice,2),2).''; echo '
' // echo ''."\n"; if($col == 3) $col = 1; else $col++; $related_prods .= '\'' . $row_related['productid'] . '\','; } if (strlen($related_prods) > 0) { $related_prods .= 'END'; $related_prods = str_replace(',END','',$related_prods); $related_sql = "AND p.productid NOT IN (" . $related_prods . ")"; } $leftover_related = $related_products - $result_related->size(); if ($leftover_related > 0) { $sql_leftover = "SELECT p.name,p.seoname, p.productid, p.description FROM products p JOIN stock s ON s.productid = p.productid WHERE p.productid != '" . mysql_real_escape_string($row_product['productid']) . "' " . mysql_real_escape_string($related_sql) . " AND p.status = 'live' AND s.status = 'live' AND (s.stock > '0' OR p.stockaction = 'show') AND s.price > 0 GROUP BY p.productid ORDER BY RAND() LIMIT 6"; $result_leftover = $db->query($sql_leftover); while ($row_leftover = $result_leftover->fetch()) { $sql_category = "SELECT c.parent AS parent1, c2.parent AS parent2 FROM productcategories pc JOIN categories c ON pc.categoryid = c.categoryid LEFT JOIN categories c2 ON c2.categoryid = c.parent WHERE pc.productid = '" . mysql_real_escape_string($row_leftover['productid']) . "'"; $result_category = $db->query($sql_category); $row_category = $result_category->fetch(); if ($row_category['parent2'] == 0) { $parents = $row_category['parent1'] . '/'; } else { $parents = $row_category['parent1'] . '/' . $row_category['parent2'] . '/'; } $sql_image = "SELECT pi.filename FROM productimages pi WHERE pi.productid = '" . mysql_real_escape_string($row_leftover['productid']) . "' ORDER BY pi.order LIMIT 1"; $result_image = $db->query($sql_image); if ($result_image->size() == 0) { $filename = 'no_image.jpg'; } else { $row_image = $result_image->fetch(); $filename = $row_image['filename']; } $sql_prices = "SELECT *, r.fldPrice AS reducedTo FROM stock s LEFT JOIN ( SELECT * FROM reductions WHERE ( fldDateStart IS NULL OR fldDateStart <= NOW() ) AND ( fldDateEnd IS NULL OR fldDateEnd >= NOW() ) ) AS r ON r.fldProductID = s.productid WHERE s.productid = '" . mysql_real_escape_string($row_leftover['productid']) . "' AND s.status = 'live' ORDER BY s.price"; $result_prices = $db->query($sql_prices); $row_prices = $result_prices->fetch(); $price = $row_prices['price']; $reducedPrice = $row_prices['reducedTo']; // Figure out image size for markup $tmpImagePath = 'http://'.$serverName.'/product_images/image_resize.php?image='.urlencode($filename).'&max_width=85&max_height=125'; $tmpImageData = getimagesize($tmpImagePath); if(is_null($reducedPrice)) $priceDisplay = '£'.number_format(round($price,2),2); else $priceDisplay = 'was £'.number_format(round($price,2),2).'
now £'.number_format(round($reducedPrice,2),2).''; if(!empty($row_leftover['description'])){ $description = $row_leftover['description']; } else { $description = "No description set"; } echo '
' .'Image preview of '.htmlentities($row_leftover['name'], ENT_QUOTES, 'UTF-8').'' .'
' .'

'.htmlentities($row_leftover['name'], ENT_QUOTES, 'UTF-8').'

'."\n" .'

'.substr(strip_tags($description), 0, 40).'...

' .'
' .'
'."\n"; $col++; } } // Slightly messy markup but we need to pad the columns out for this design to work if($col > 1) { while($col < 4) { echo '
 
'; $col++; } } ?>

Secure online shopping

You can pay online with these credit and debit cards:

Visa, Mastercard, Switch, Solo, Maestro • Thawte SSL Security

Terms & Conditions | Contact | Site Map

The Fusilier Museum is a Registered Charity (Registered in England No. 206186), Tel: 01494 601 300

eCommerce development leeds by newmediaboutique

*/ ?>