C Mysql Api

hi all..
can anybody point me how to insert into database tables,using Structures in C.
i'm using MYSQL.
code:
---------------------------------
typedef struct{
int id;
int frequency;
int mod;
}my_struct;

my_struct *abc={
{1,10,22},
{(0,0,0)}
};

--------------------------------------
i want to insert this sample entries into table 'channel'...
please help me with the proper query for this..

any response is highly appretiated.
thanks in advance.
fazz.

So . . . you want your C program to automate typing commands?

yeah,
actually my insert fuction has to take struct-pointer as argument,and
insert into corresponding columns in the 'channel' table,like this:
--------------------
my_error Insert_channel (my_struct* list, int items) // items is the number of list items.
------------------------
eg.
my_struct abc={
{1,10,22},
{0,0,0}
};
/*Return :
my_error
Input Arguments:
List (Null terminated structure)
Items (no of items in the structure)
-------------------------
plz reply ...
thanks.
fazz

And we're supposed to know how your table looks like?

Code tags, use the [code][/code] tags!

here's my table creation statement:

Code:

"create table `channel`(`id` int(11) auto_increment PRIMARY KEY,`frequency` int(11) ,`mod` int(11))";

So what exactly are you asking that can't be fixed by
a) reading http://dev.mysql.com/doc/refman/5.0/en/c.html
b) trying some of the examples provided
c) adapting them to refer to your table name and field names
d) writing a for loop to iterate over your input array to insert data into the table.

hint:

Code:

int mysql_query(MYSQL *mysql, const char *query)

Executes the SQL query pointed to by the null-terminated string query. Normally, the string must consist of a single SQL statement and you should not add a terminating semicolon (‘;’) or \g to the statement.

If you know SQL and C, the rest is easy! And don'r forget to commit your INSERT !

yeah..
that works..
thanks..
fazz