You don't need to use mysql_num_rows.

Code:
ackmysql_query_result_threaded("SELECT pass FROM users WHERE User='dddd'", 1);

while(ackmysql_query_state() == ACKMYSQL_RUNNING) {wait(1);}

ackmysql_fetch_row(1, 0, result);