ackmysql_query_result returns a BOOL.
1 = TRUE = ACKMYSQL_SUCCESS
0 = FALSE = ACKMYSQL_FAILURE
You need to use the result you stored before with ackmysql_query_result as parameter.
row_num = ackmysql_num_rows(1);
You stored the result in an array with as index of 1.