OK, i think what you need to do is this:
images/product_thumb/<?php echo str_replace("detail", "thumb", $row_WADAproducts["ProductImage"]); ?>
Since the field in your database it probably named image_detail.jpg but you want o display image_thumb.jpg. So the above replacement will replace detail with thumb.