struct phonecard { int *cardid; char number[13]; int *credit; int *ratechangepercent; int *ratechangestatic; int *connectcharge; int *increment; int *inuse; int *expire; int *active; char *callerid; }; /* put the values into the structure */ row = mysql_fetch_row(result); card->cardid = row[0]; card->credit = row[1]; card->ratechangepercent = row[2]; card->ratechangestatic = row[3]; card->connectcharge = row[4]; card->increment = row[5]; card->inuse = row[6]; card->expire = row[7]; card->active = row[8];