Help on Query Sql

[Limestone]

hi how can I randomly set cash point to my account using query_sql?

 

example:

query_sql ("UPDATE `cash` SET `cash_point` = cash_point + rand(100,1000) WHERE `account_id` = '"+getcharid(3)+"'");

 

if i use the item, this is the error. DB error - Operand should contain 1 column(s)

 

Thanks!

[Ninja]

I suggest you use

set #CASHPOINTS, #CASHPOINTS + rand(100,1000);

Instead of doing an sql query

Edited September 2, 2015 by jezznar