Update SQL failed

[mihaamiharu]

Hi everyone, i have a script to change the value from selected SQL.

The script was running smoothly without error, but the value of SQL column is not changed.

The function of this script is add extra bonus cash point when you entered specific voucher, and accumulated bonus that will given to the voucher owner.

 

My DB Structure

CREATE TABLE `promorefeeral` (
  `refeeralcode` varchar(24) NOT NULL,  // Special Voucher code
  `used` int(11) NOT NULL, // How many times this voucher was used
  `extra` int(11) NOT NULL,  // Total bonus get when used this voucher
  `komisi` int(11) NOT NULL // Acculumated bonus get by the voucher owner
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

 

//Used variable on sql query

mes "Please Input your refeeral code";
            input .@ref$;

.@bonus = (.@amount * .@extra )/ 100;

my sql query :

//

.@b = query_sql("SELECT * FROM `promorefeeral` WHERE `refeeralcode` = '"+escape_sql(.@ref$)+"'",.@refeeral$,.@used,.@extra,.@komisi);

query_sql("UPDATE `promorefeeral` SET `used` = + '1', `komisi` = `komisi` + '"+.@bonus+"' WHERE `refeeralcode` = "+"'+.@refeeral$+'");

 

====

When i use refeeral on database, the amount of cash point is successfully added.

But the column used, and komisi is not changed.

 

 

 

 

 

 

 

Edited March 6, 2021 by mihaamiharu