i want to pass a verible in mysql_query
i tested following code but compile error came for that
accntnbr = [(whatever the variable is)];
amount = [(whatever the variable is)];
query = "insert into tablename (acctnbr,amount) values (%s,%s)",acctnbr,amount);
what is the right and easiest way for that?