All Cat's same style

[NJAquaman]

how can i run a SQL Queries to make all my Cat's the same style ?
is their any options or ticks i can do ?

thank :D

[Brian]

Are you trying to change the 'Custom Style For This Category' setting for all categories, certain category settings, or...?

[Our Sponsors]

[NJAquaman]

Are you trying to change the 'Custom Style For This Category' setting for all categories, certain category settings, or...?

In each Category i need to change the style ... but i have over 100 cats to deal with and i wanted to how it their was a quicker way of changing the "Custom Style For This Category" in each catergory ???

thanks

[Brian]

This will update them all. Just be sure to replace the X with the styleid that you would like to use.

UPDATE adv_dyna_categories SET styleid = X

Also note you may need to edit one (any) of your categories though the Admin CP afterward and save it so it will call the code to update the category cache.

[Our Sponsors]

[NJAquaman]

Worked like a charm and saved me a tone of work !!!

Also note; I used it for my second instance of dynamics (dyn2)

UPDATE adv_dyn2_categories SET styleid = X

thanks so much Brian