Post by barthez0705 » Mon Apr 02, 2012 9:25 pm

Buna ziua. Am o intrebare, daca ma poate ajuta cineva, nu ma prea pricep la SQL dar din cate stiu, cred ca pot insera in toate liniile din product_tag la tag niste cuvinte de baza pentru fiecare produs. De exemplu vreau cuvantul1, cuvantul2, cuvantul3, cuvantul4, cuvantul5, sa apara la fiecare produs din magazinul meu in campul Meta Keywords.

Poate cineva sa imi scrie un cod de inserare ca sa fac asta prin phpmyadmin odata pentru toate produsele? Si nu la fiecare produs pe rand?

Newbie

Posts

Joined
Sun Mar 11, 2012 5:11 pm


Post by florinsith » Tue Apr 03, 2012 12:05 am

Aceleasi cuvinte la toate produsele?

Image
My Extensions - SuperTheme - Opencart templates - Opencart modules


User avatar
Expert Member

Posts

Joined
Fri May 14, 2010 2:36 am


Post by barthez0705 » Tue Apr 03, 2012 1:36 am

Da. Sunt 5 cuvinte, care vreau sa fie predefinite la fiecare produs, la campul Keywords.

Newbie

Posts

Joined
Sun Mar 11, 2012 5:11 pm


Post by florinsith » Tue Apr 03, 2012 2:40 am

In phpmyadmin, la tabul sql, ruleaza interogarea:

Code: Select all

update product_description set meta_keyword = "cuvant1, cuvant2, cuvant3, cuvant4, cuvant5"

Image
My Extensions - SuperTheme - Opencart templates - Opencart modules


User avatar
Expert Member

Posts

Joined
Fri May 14, 2010 2:36 am


Post by barthez0705 » Tue Apr 03, 2012 3:02 am

Mersi mult. Acum o rulez.

Newbie

Posts

Joined
Sun Mar 11, 2012 5:11 pm


Post by barthez0705 » Tue Apr 03, 2012 3:12 am

Perfect. A mers foarte bine. Multumesc inca odata!

Newbie

Posts

Joined
Sun Mar 11, 2012 5:11 pm

Who is online

Users browsing this forum: No registered users and 4 guests