still dont get it..
error need '('
query_sql "INSERT INTO `redeembetalog` (`code`, `item_amount`,`name`, `time`) VALUES ('"+@voucher_code$+"', '"+@amt+"', '"+strcharinfo(0)+"', '"+SELECT NOW() + 1;+"')";
still error
script:add_word: invalid word. A word consists of undercores and/or alphanumeric characters, and valid variable prefixes/postfixes.
query_sql "INSERT INTO `redeembetalog` (`code`, `item_amount`,`name`, `time`) VALUES ('"+@voucher_code$+"', '"+@amt+"', '"+strcharinfo(0)+"', '"+gettimestr("%Y-%m/%d %H:%M:%S",21);+"')";
thank you Patskie,Emistry, and Start_
solved.. that escape_sql and now() works..