Sure - you could simply change categories.php to use the category mapping table instead of the products table. In that file, look for the following code at line 6:
$sql = "SELECT DISTINCT(category) as category FROM `".$config_databaseTablePrefix."products` ORDER BY category";
...and REPLACE that with:
$sql = "SELECT name as category FROM `".$config_databaseTablePrefix."categories` ORDER BY category";
Hi Marco,
Sure - you could simply change categories.php to use the category mapping table instead of the products table. In that file, look for the following code at line 6:
$sql = "SELECT DISTINCT(category) as category FROM `".$config_databaseTablePrefix."products` ORDER BY category";...and REPLACE that with:
$sql = "SELECT name as category FROM `".$config_databaseTablePrefix."categories` ORDER BY category";Cheers,
David.
--
PriceTapestry.com