#include <stdio.h>
#include <stdlib.h>
#include <sqllib.h>

int main(void)
{
	MYSQL_ROW row;
	int i, fc;
	MYSQL_FIELD *field[25];
	
	if (! sql_connect(0, "localhost", "", ""))
		exit(1);

	if (! sql_selectdb(0, "logbook"))
		exit(1);

    if (! (fc = sql_query(0, "SELECT * FROM logbook where callsign like 'm4'")))
		exit(1);

    printf("%d\n", fc);

	for (i = 0; i < fc; i++)
		field[i] = sql_fetchfield(0);

	while (row = sql_fetchrow(0)) {
		for (i = 0; i < fc; i++) {
			if (row[i] == NULL)
				printf("%s\n", field[i]->name);
			else
				printf("%-15s %s\n", field[i]->name, row[i]);
		}
		printf("********************************************\n");
	}

	if (! sql_endquery(0))
		exit(1);

	if (! sql_disconnect(0))
		exit(1);
		
	exit(0);
}

.