your link on the home page passes the product name:
products_detail.php?prodID=Test%20Product%2010
instead of passing the ID:
products_detail.php?prodID=10
you need to edit the link on the home page so it passes the ID column value not the name.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.