I'm trying to write a sql script to update the categories images.
The database that will write the script has the image name and the category name but not the category ID.
My problem is that the names are in one table but the images in another.
I tried...
but this updated every category.update 'zen_categories_description`,`zen_categories` set zen_categories.categories_image = 'test2.jpg' where zen_categories_description.categories_name = "Fittings"
There will be over a hundred of these, so manual entry is not realistic.
Any help is appreciated.
Jeff
Bookmarks