Magento Load Product By Name / SKU / ID

// Load by name
$_category = Mage::getModel('catalog/category')->loadByAttribute('name', 'Ruby Ring');
$_product = Mage::getModel('catalog/product')->loadByAttribute('name', 'emerald earring');
 
// Load by SKU
$_product = Mage::getModel('catalog/product')->loadByAttribute('sku', 'Eram18j4');
 

//Load by ID (just load):
$_product = Mage::getModel('catalog/product')->load($productID);




example:



<?php
$productID = $this->getProduct()->getId();
$_product = Mage::getModel('catalog/product')->load($productID);
//echo '<pre>';
//print_r($_product);
?>

<img src="http://54.219.137.93/magento/media/catalog/product<?php echo $_product->getSmallImage(); ?>" width=100 height=100 />
<?php

echo '<br/>';
echo "List Price";
echo $_product->getPrice();
echo '<br/>';
echo "Sale Price";
echo $_product->getSpecialPrice();





?>