take it from me.....mysql and c are a pain in the ***. there is an api for mysql, though, but there are a few things you might want to know:
/*all this applies to unix*/
to compile, type this:
gcc -g -o -L/*directory*/lib -I/*directory*/include -lmysqlclient -lm
where I put *directory*, put the location of your mysql folder. This should be something like /usr/local/mysql/
then....here are some code snippets you can use:
/*connect to mysql*/
mysql_init(&mysql);
connection = mysql_connect(&mysql, "localhost", "9841860u", "9841860u");
/*check for a connection error*/
if(connection == NULL)
{
/*print error message*/
printf(mysql_error(&mysql));
}
/*select a database*/
mysql_select_db(&mysql, "Nag");
/*here you create a string to pass as a query...you have to do it this way (I think) because you can't pass mysql a variable from C*/
strcpy(query, "SELECT column FROM table WHERE variable = ");
strcat(query, x);
state = mysql_query(connection, query);
if(state != 0)
{
printf(mysql_error(connection));
}
/*this will give you a result set (if you are expecting a result)...you can go through that with row=mysql_fetch_row(result)*/
/*before you can call another query that will return a result set, you must free the result set*/
mysql_free_result(result);
/*close the mysql connection*/
mysql_close(connection);
there are a whole load of functions and structures used, just go through the c api section of the mysql manual.....you can get that online
hope I was of help,
good luck,
Des.
:p