when i use this code: (Omit some code...such as sqite3_stmt)
sqlite3_prepare("select * from table1 where $fieldname = $fieldvalue")
sqlite3_bind_text("$fieldname", "id"); //the "id" is a field of table1, this line maybe got error.
sqlite3_bind_int("$fieldvalue", 5);
sqlite3_step();
...
I wonder if these code get the SQL: 1. select * from table1 where id = 5 //this is what i want or 2. select * from table1 where 'id' = 5 //this is what i don't want!
Another question:
I use sqlite static lib in my applictiaon, and How I can get the debug info that comes from sqlite3DebugPrintf() or other?
thanks, liigo