PHP MYSQL join tables

I am designing a product page for an e commerce site. I have a repeat
region set up in my server behavior but I am not sure how to join tables. I
have the following set up:

{rsproducts.PRODID} - {rsproducts.PRODNAME}
{rsproducts.PRODDESC}
{rsproducts.PRICE}
{rsimages.LINK}{rsimages.LARGEPIC}

Now, of course, this works fine except that I get the same
{rsimages.LINK}{rsimages.LARGEPIC}displaying to each unique item.

How to I join {rsimages.PRODID} and {rsproducts.PRODID}in order to display
the proper picture with the item?

My SQL statement is

SELECT images.LINK, images.SMALLPIC, images.LARGEPIC, product.PRODID,
product.PRICE
FROM images, product
WHERE images.PRODID = product.PRODID

Thanks in advance.