Details
Street Edge C-Notch Kit for 88-98 Chevy Silverado/C-1500/GMC Sierra Regular Cab 2WD C-Notch
$product_id = Mage::registry('current_product')->getId();
$pid = $product_id;
//echo $pid;
$db = Mage::getSingleton('core/resource')->getConnection('core_write');
$query = 'SELECT `afv1`.`name` as `name1`,`afv2`.`name` as `name2`, `afm`.`value_id` as `resid` FROM `am_finder_map` as `afm`'.
'INNER JOIN `am_finder_value` as `afv1` ON `afv1`.`value_id` = `afm`.`value_id`'.
'INNER JOIN `am_finder_value` as `afv2` ON `afv2`.`value_id` = `afv1`.`parent_id`'.
'WHERE `pid` = '.$pid;
$finders = $db->fetchAll($query);
if(empty($finders)) {
echo"
".$this->__('Er zijn geen modellen gevonden.')."";
}else{
foreach ($finders as $finder){
$link = 'http://exacmple.com/part?find=';
$link .= strtolower(preg_replace('/[^\da-zA-Z]/', '-', $finder['name2'])) . '-'.strtolower(preg_replace('/[^\da-zA-Z]/', '-', $finder['name1'])) . '-'.$finder['resid'];
echo "
".$finder['name2']." - ".$finder['name1']."";
}
}