I'm half competent with C, I've spent all morning looking over the SQLite documentation and I can't work out what I need to do.
I need a program which will ask user for their input, and then in-turn puts that into an SQL statement.
For example, the program would prompt the user to enter their name, after they've done that it stores their name in a variable and puts that variable into the following argument
INSERT INTO tablename VALUES(value1,value2,mystring)
Not asking for anyone to do it but could someone point me in the right direction, or at least confirm this is possible? Smashing my head against the wall at the moment.