I have a simple sqlite query. I have been able to query specific data or Static data, but I'm having trouble querying variables. I'm not new to SQL queries, but I am new to cocoa. Can someone give me a simple example of querying a variable? The following is my query: const char *sql = "select id, name from field where name = 'variable' "; sqlite3_stmt *selectStatement; Thanks For the help Okay maybe no one understands what I need. I'll try to explain this better. If I were to write an SQL query with a Variable it would look like this: $sql ="SELECT Name FROM `TableName` WHERE id = '".$ID10."'"; $sql = SQL Variable SELECT = What To Select Name = Row Name In The Table FROM = Where To Select From 'TableName' = Is The Name Of The Table Where id = Where The id is '".$ID10.'" = variable The last variable is where I'm having trouble. Can anyone help?