Hello,
This is a MySQL regarding quetion.
My program is connected to MySQL via unix command line. I am pretty happy with executing all commands and geting results of queries. But now I need something I cannot do.
I need to iterate thru the table or the query result (the view) with "Previous" and "Next" commands.
like:
1. Go to table (view) entry X
2. GetField("Name")and do something with it (say send email to the personrr ecorded in the database)
3. Go to the next record.
mysql returns the entire set of records, but I need them one by one and hours and days of reding manuals didn't help to find a solution. I don't want to load all records into memory and deal with them manually in arrays, why the h..l I need the database then?
Anyone can help? Maybe I have to switch to c++ api for mysql in order to use prev, next and get field?
Also I'd like to iterate thru fields of the result record like:
for (i = 0; i < fieldcount; i++) getfieldbyindex(i);
Thank you,
Yakov
This is a MySQL regarding quetion.
My program is connected to MySQL via unix command line. I am pretty happy with executing all commands and geting results of queries. But now I need something I cannot do.
I need to iterate thru the table or the query result (the view) with "Previous" and "Next" commands.
like:
1. Go to table (view) entry X
2. GetField("Name")and do something with it (say send email to the personrr ecorded in the database)
3. Go to the next record.
mysql returns the entire set of records, but I need them one by one and hours and days of reding manuals didn't help to find a solution. I don't want to load all records into memory and deal with them manually in arrays, why the h..l I need the database then?
Anyone can help? Maybe I have to switch to c++ api for mysql in order to use prev, next and get field?
Also I'd like to iterate thru fields of the result record like:
for (i = 0; i < fieldcount; i++) getfieldbyindex(i);
Thank you,
Yakov