Variables/parameters in Sqlite query for Iphone App

Answer 1

Well, first change your query to your parameterized query like you have there. Then, just before you call sqlite3_step bind the right id to the parameter:

sqlite3_reset(getVisuelStatement);

//Add these two lines
int visuelId = 1;  //Put whatever id you want in here.
sqlite3_bind_int(getVisuelParcStatement, 1, visuelId);

while(sqlite3_step(getVisuelParcStatement) == SQLITE_ROW) {