SQL Count

[Limestone]

how can i make a query_sql script like this

 

"you have a total of "+.@n+" Credits";

 

here's my script

 

set .@n, query_sql "SELECT `balance` FROM `cp_credits` WHERE `account_id` = '" + getcharid(3)+ "'";

[DeadlySilence]

You can do it like this:

query_sql("SELECT `balance` FROM `cp_credits` WHERE `account_id` = " + getcharid(3), .@balance);

 

For every column you select you have to add another value at the end. If you want to select `balance` and `account_id`, you'd do it like this:

query_sql("SELECT `balance`, `account_id` FROM `cp_credits`", .@balance, .@accountId); 

[Patskie]

If multiple rows are returned by the query. You can use like the following in sql :

SELECT SUM(column_name) FROM table_name WHERE value = some_value;