how can i pass veriable in mysql_query

i want to pass a verible in mysql_query
i tested following code but compile error came for that
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);


what is the right and easiest way for that?
thanks

Do like so...

$var1 = "4352";
$var2 = 45.00;

$query = "insert into table (acctnbr,amount) values ('$var1', '$var2')";
mysql_query($mysql,$query);

------------------
PHP, Perl, SQL Programming at http://www.mentalobjects.com