Street Edge C-Notch Kit for 88-98 Chevy Silverado/C-1500/GMC Sierra Regular Cab 2WD C-Notch

Details

Additional Information

Free Shipping	N/A
Front Lowering Range	N/A
Rear Lowering Range	N/A

$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']."
"; } }