Magento

<?php 
	$_category = Mage::getModel('catalog/category')->load(3);
 
	$_testproductCollection = Mage::getResourceModel('catalog/product_collection')
	->addCategoryFilter($_category)
	->addAttributeToSelect('*');
	$_testproductCollection->load();
 
	foreach($_testproductCollection as $_testproduct){ 
		echo $sp_name = $this->htmlEscape($_testproduct->getName()); 
		echo $sp_desc = $this->htmlEscape($_testproduct->getShortDescription());
		echo $sp_image = $this->htmlEscape($_testproduct->getImageUrl());
		echo $sp_url = $this->htmlEscape($_testproduct->getUrlPath()); 
		echo $sp_price = $this->htmlEscape($_testproduct->getPrice()); 
	};
?>