Hi david,
And could put the store as the attached picture, low price.
when the number of suppliers will leave the name of cheaper
{image saved}
thanks
Hi David,
Perfect 100%, now just to put it under the price and change the font color, now comes under the photo
Hi Carlos,
Sure - however where there are more than one merchant it does require a second database query to retrieve the cheapest merchant since search results are created using what is known as a "summary" query in SQL so the actual value of the merchant field is undefined (it will be consistent, but no necessarily the cheapest). Therefore, make sure that performance on the search results pages remains acceptable with this mod in place.
To do this, look for the following code in html/searchresults.php around line 30:
<?php endif; ?>...and REPLACE with:
<?phpif ($product["numMerchants"] > 1)
{
$sql = "SELECT merchant FROM `".$config_databaseTablePrefix."products` WHERE name='".database_safe($product["name"])."' ORDER BY price LIMIT 1";
database_querySelect($sql,$result);
$merchant = $result[0]["merchant"];
}
else
{
$merchant = $product["merchant"];
}
print "<br /><span class='nobr'>".$merchant."</span>";
?>
<?php endif; ?>
Cheers,
David.
--
PriceTapestry.com