Newbie Question - How to retrieve products from a specified category

[Pepozzo]

Hello!

 

I'm trying to write my first module.

 

I followed the documentation found here http://doc.prestashop.com/display/PS14/Creating+a+PrestaShop+module but now i'm trying to retrieve all products that are in the "Home" category.

 

So, i don't know two things.

 

How can i write the query?

I guess it isn't like i usually do in PHP.

 

And then, in my .tpl file how can i display the result?

 

Thanks guys!

[hulk]

you can use the some thing in homefeatured module, it retrieve all product in "Home" category.

 

just modify it to have the result that you need

[Pepozzo]

Yeah, i tought the same, but if i want to show, for example, only some of "new products"?

 

Just to learn.

 

Actually i would like to develop a module with an administration panel where i can choose some products from the "new products" and then display them on a block in the home page (left or right side only). That's my idea, but obviusly, step by step.