Here's the code to add to html/noresults.php for 10 random products...
<?php $sql = "SELECT *,COUNT(id) AS numMerchants,MIN(price) as minPrice FROM `".$config_databaseTablePrefix."products` GROUP BY search_name ORDER BY RAND() LIMIT 10"; if (database_querySelect($sql,$rows)) { $searchresults["products"] = $rows; foreach($searchresults["products"] as $k => $product) { $searchresults["products"][$k]["productHREF"] = tapestry_productHREF($searchresults["products"][$k]); } require("html/searchresults.php"); } ?>
Hi,
Here's the code to add to html/noresults.php for 10 random products...
<?php$sql = "SELECT *,COUNT(id) AS numMerchants,MIN(price) as minPrice FROM `".$config_databaseTablePrefix."products` GROUP BY search_name ORDER BY RAND() LIMIT 10";
if (database_querySelect($sql,$rows))
{
$searchresults["products"] = $rows;
foreach($searchresults["products"] as $k => $product)
{
$searchresults["products"][$k]["productHREF"] = tapestry_productHREF($searchresults["products"][$k]);
}
require("html/searchresults.php");
}
?>
Cheers,
David.
--
PriceTapestry.com