Pulling Values from Database for specific products

[maksum]

I am creating a custom PHP page for this store I'm working on. I would like to display titles and prices for specific products. I know the "product_id". Is there a piece of code that will allow me to pull that info?

 

I am able to link up to the "details" and "buy it now" using the following:

 

 

<A HREF="product_info.php/products_id/118">...</A>

<A HREF="?action=buy_now&products_id=118">...</A>

 

But I can't figure out how to call in the price and title.

 

Thanks in advance for any help you can offer. I know very little PHP, so if you have a snippet of code, that would be awesome.

 

Mike