Problem with query

[gregarion]

Hey guys I want to insert values into a MySql database. The following line works fine:

mysql_query(connection, "INSERT INTO main (NumofShows , Title) VALUES('12', 'Home')");

What i would like to do is instead of having to hardcore the inserted values into the querty, i would like it to read from a variable. For exmaple the data to be inserted is from a string... like....

string NewTitle = "Monaco";
string NumofShows = "2";

How do i edit my sql statements so variables can be inserted into the Insert statement so the query will read the variables and then store their values in the database. Really need some help in this

[loyal ginger]

Use a parameters with the command object so you don't hard code values in the SQL statement.

[gregarion]

Im not sure what you mean. Could u edit my example to show me what you mean?