Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / SQL command to update category images?

SQL command to update category images?

Locked

Views: 759

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
2 Dec 2009, 9:53 PM
#1
jeff_g avatar

jeff_g

Zen Follower

Join Date:
Oct 2007
Posts:
132
Plugin Contributions:
0

SQL command to update category images?

I have a file that includes SQL commands to update my category images. Each line in the file looks like this...

update categories,categories_description set categories.categories_image = '014.jpg' where categories_description.categories_name = 'Malleable #150 Thread Fittings' and categories.categories_id = categories_description.categories_id;
It works fine using phpMyAdmin, but I cannot execute it using the SQL Query Executor/Install SQL patches with ZC admin.

I have 2 questions.

  1. How do I (can I?) modify to execute from within ZC?
  2. Does anyone have a better way to do this?

Thanks,
Jeff