There are a number of different ways to gather input and interact with mysql. If you're looking to do text mode user interaction through a C API, ncurses is commonly used (http://dickey.his.com/ncurses/ncurses.faq.html
). I personally prefer a web based interface for most circumstances, but a discussion about web techniques and starting points could lead on quite a long and complex tangent.
As far as MySQL interaction, the C API for mysql is documented in chapter 8 of their documentation (http://www.mysql.com/documentation/m...s.html#Clients
However, I more normally use Perl for interacting with MySQL (http://www.perl.com/pub/a/1999/10/DBI.html
). Perl might be worth a look if what you're doing are one-off integration projects. Discussions about the benefits of Perl and C and where each should be used are the type of thing that could start religous wars, so I'll leave the topic alone.
It can be quite difficult to compare and contrast different technologies if you don't have any practical experience with them. Fortunately, if what you're interested in are open source alternatives, the only capital investment you need to make in order to evaluate them is the time required to read a few websites and manual pages and install the software. That's really the best way to make the decision here. You have a lot of alternatives. I would say pick a few of them and try implementing an evaluation project with them. And even if the first alternative you try seems to work "perfectly", still try some others so that you have a broader base of experience. http://leapster.org/linoleum/
lists links to documentation about all different areas of Linux and *nix related programming. Experiment and learn. -- Rev