how can i pass a variable in mysql_query?

i want to add a record in a table but
through a varible
mysql_query( &mysql, "INSERT INTO tablename(acctnbr, amount) VALUES (12345, 651.30)" );

i want to pass the value of acctnbr and amount through veriables how can i do it ?
thanks....

In PHP:

$result=mysql_query("insert into tablename (acctnbr,amount) values ($acctnbr,$amount)");

i want to know about c coding not for php
to pass a veriable in mysql_query function.
thanks...

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by abbas:
i want to know about c coding not for php
to pass a veriable in mysql_query function.
thanks...[/quote]

this should work

String query,acctnbr,amount;

accntnbr = [(whatever the variable is)];
amount = [(whatever the variable is)];

query = "insert into tablename (acctnbr,amount) values (%s,%s)",acctnbr,amount);
mysql_query(&mysql,query);

error:
String not allow to compile
if i use
char accout[30]
and use your formate then not happen any thing after run the program.
thanks
please review your query is it right?