url elements not showing
Hey Ray
Not sure why the element 'ManPermalink' is not being shown on the front end of the site for this:
<a href="shop/<?php echo($FeaturedProductPanel->getColumnVal("ManPermalink")); ?>/<?php echo($FeaturedProductPanel->getColumnVal("ProdPermalink")); ?>" class="responsive-picture featuredProductImage">
On the live site this looks like http://www.domainname.co.uk/shop//productname which, as you can see, omits the brand name between shop and productname
The recordset is
<?php
$FeaturedProductPanel = new WA_MySQLi_RS("FeaturedProductPanel",$DBConnection,1);
$FeaturedProductPanel->setQuery("SELECT products.*, productmanufacturers.ManufacturerName, productcategories.CategoryName, (SELECT sum(OptionPrice) FROM optiongroups INNER JOIN options ON options.OptionGroupID = optiongroups.OptionGroupID WHERE OptionProductID=ProductID) AS OptionPrice FROM products INNER JOIN productmanufacturers ON products.ProductManufacturerID = productmanufacturers.ManufacturerID INNER JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID WHERE products.ProductLive = 1 ORDER BY Rand()");
$FeaturedProductPanel->execute();
?>
cheers
Jamie