you need to filter the recordset to get the correct record.
if this is a product detail page, the link to the detail page will contain a URL variable to pass the product iD:
productDetails.php?productID=4
in the recordset, set it to filter the product id column on the productID URL variable.
you can use whichever id makes your page look the way you want it to.