Forum

In PHP, I have used the following:

           $query=”SELECT * FROM `zipcodes` WHERE zip =  '$czip'”;

The table is zipcodes, zip is a field in the table. czip is a variable from input. So, I can retrieve all the instances of czip from zipcodes by using the construct '$czip'.

How can this be done in XCode in a const char statement?

Thanks, but I needed to use a string as the ? See my Tips and Tricks Post

Use the sqlite3_bind_text() function instead of sqlite3_bind_int() if you want to replace a placeholder ? with a string.

sqlite3_stmt *insert = nil;

const char *sql = “SELECT * FROM zipcodes WHERE zip='?'”;

sqlite3_prepare_v2(database, sql, -1, $insert, NULL);

sqlite3_bind_text(insert, 2, [czip UTF8String], -1, SQLITE_TRANSIENT);

assuming czip is an instance variable of self. You could also use an array of strings, or input as czip.

Yeah, I don't really see the problem.. Just build a sql statement like the one in youre post and loop through the results.