I can't sort products by price, please help

[dmaldonado_ids]

Hello, I am new on magento, I just start a week ago and a I have a strange ( for me ) trouble...

$category = Mage::getModel('catalog/category')->load(4);
            
$products = $category->getProductCollection()
                    ->addAttributeToSelect('name')
                    ->addAttributeToSelect('price')
                    ->addAttributeToSort('price', 'DESC');

I get all products from a category, and then I want to sorted by price, this is my code:

When I see the query is doing a join type inner with a table named "catalog_product_price_index" which is empty, you imagine my problem... I re-index the data via admin but still doesn't work.

Thanks.

[Dhiren Vasoya]

Hi @dmaldonado_ids

These links can help you out:

1. http://magento.stackexchange.com/questions/3488/how-to-sort-special-price-collection
2. http://magento.stackexchange.com/questions/10305/how-to-list-products-in-descending-order