Sqlite3 update statement problem

Question

how to create SQl statement for update using 'where' condition with 'name', how to bind this name to sql statement...

///example 
const char *sql = "update profile set name = ? ,Lname = ?, date = ?,phno = ? ,image = ? , id= ? where **name=?**;";

Answer 1

What is the problem? You can just use sqlite3_bind() Each parameter has a numbered index starting at 1. You just call sqlite3_bind() for each of the question marks. The first 'name' is parameter number 1 and the second one is parameter number 7.