Get product names of current category

Hello I am working on a auto generating content module for categories and i want to display as text the titles of the products that are in that category,
but i just cant figure out from where to get their names, ONLY PRODUCT NAMES without url or image.

Any ideas?

perfumbg:

Hello I am working on a auto generating content module for categories and i want to display as text the titles of the products that are in that category,
but i just cant figure out from where to get their names, ONLY PRODUCT NAMES without url or image.

Any ideas?

SELECT products_name FROM products_description WHERE products_id = $ID ; // Set $ID to match the product of interest.

Does that help? If not, perhaps if you supply a copy of a portion of the code that you are working with I/we will be able to give a more specific response.

Cheers
Rod

RodG:

SELECT products_name FROM products_description WHERE products_id = $ID ; // Set $ID to match the product of interest.

Does that help? If not, perhaps if you supply a copy of a portion of the code that you are working with I/we will be able to give a more specific response.

Cheers
Rod

I used different aproach and forgot to mention it here.
but your code works fine too.

Thanks a lot.