Page 1 of 1

updating phpmyadmin colunm shipping based on weight

PostPosted: 27. April 2016 11:27
by marlonvassallo

I would like to update the shipping column based on the weight of the product from another column (same table)

for example:

if weight =<29 than shipping 2.00 else if weight =<99 shipping 5.00 and so on.

any ideas how i can do this?