Cofusing in Updating the table

Databases
1

@r937,


    CREATE TABLE `pairingtbl` (
          `parentid` INT(11) NULL DEFAULT NULL,
        `left` INT(11) NOT NULL,
        `right` INT(11) NOT NULL,
        `pairamount` DECIMAL(10,2) NOT NULL
    )
    COLLATE='latin1_swedish_ci'
    ENGINE=InnoDB
    ;

I am working in MLM project and I want to update

pairing table

parentid  left  right  pairingamount
11        19          0.00
19        21   22       1000.00

Now I want to update the amount of parentid 19 to add amount 100.00.,because it has completed left and right then also parentid 11 because it is the parentid of 19 and so on to it’s parents id.

can you help me please what should I do.

Thank you in advance.

2

sorry, i cannot help

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.