you need to filter the recordset to return the product for that page.
the problem you are having is that you are using a database for the add to cart button, but the pages are static.
normally the pages would be dynamic and the navigation would filter the recordset by passing the product ID as a querystring variable.
since your pages are static, you need to filter the recordset on the page so that it returns the correct record.