willieray25 Posted October 20, 2008 Share Posted October 20, 2008 Hey team! I have a ? that's kinda stumping me... I might be thinking about it too much. Maybe you can help. I have a table with product information in a MySQL db. I want to replace the image_name field for all products that have an image to be the valid path for the image. The image names are identical to the model_no field besides having the '.jpg' extension. I have populated another table called images with a single column listing of the image name. example: product.model_no = 4-01212 image.image_name = 4-01212.jpg now i want to replace the exisiting default image path in product.image_name to 'manufacturer/'$image.image_name but only for products that have an existing image in the image db. Clear enough? any ideas? Quote Link to comment Share on other sites More sharing options...
fenway Posted October 22, 2008 Share Posted October 22, 2008 Why do this in the db? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.