Sql syntax

view full story

http://www.linuxquestions.org – Hey guys I want to insert values into a MySql database. The following line works fine: 1 Code: mysql_query(connection, "INSERT INTO main (NumofShows , Title) VALUES('12', 'Home')"); but if the data to be inserted is from a string... like.... Code: string NewTitle = "Monaco"; string NumofShows = "2"; How do i edit my sql statements so variables can be inserted into the Values ( ) , and it will be able to read the variables and then store it into the database. (HowTos)