Re: C API: problems retrieving data

[Arend-Jan Wijtzes]

It looks like you're not setting up the FIELDS structure the right way.
You must have something like:

res_set = mysql_store_result(mysql);

int num_fields = mysql_num_fields(result);
MYSQL_FIELD** fields = (MYSQL_FIELD**)malloc(num_fields * sizeof(MYSQL_FIELD*));
int n;
for (n=0; n < num_fields; n++ ) {
fields[n] = mysql_fetch_field(res_set);
}

now the fields are set properly and you can inspect them.

Note that I did not test the code above just typed it in, but you should get the idea what's going on.