it might be easy , or even newbie thing. but i am new to all of this, and i'd really appreciate if you help me.
I have wix store, in product page i created an "related items" area :
now my question is : I have created Database named RelatedItem , the purpose of this DB is :
for each product, there's 3 columns : Relatedone, RelatedTwo , RelatedThree. That means, for each product, it has three related products ID See image below:
now what i am trying to do , is: when I enter a product page, I get the Product it. Im trying to query the RelatedItem to find the productID im standing on right now, and get the three related items IDs in variables. I know sql but i do not know right it in wix! something like: SELECT relatedOne,relatedTwo,relatedThree FROM relatedItem WHERE (ID of product in the page im on rightnow) == productId
I wanted something like that: search for the productId in RelatedItem DB Once you find it do: Var Item1 = relatedOne
Var Item2 = relatedTwo
Var Item3 = relatedThree Thats it for now, I am failing to walk through this step. can anyone please help me?! Thank you!