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? Link to comment https://forums.phpfreaks.com/topic/129309-replace-using-variables-help/ Share on other sites More sharing options...
fenway Posted October 22, 2008 Share Posted October 22, 2008 Why do this in the db? Link to comment https://forums.phpfreaks.com/topic/129309-replace-using-variables-help/#findComment-672022 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.