> On 28 Jul 2014, at 12:41pm, Jonathan Moules > <jonathanmou...@warwickshire.gov.uk> wrote: > > *$table_prefix* which will be a number indicating which table set to look
You can't have variable table names in a prepared statement. The process which does preparation has to know which table it will be accessing. If you don't know which table you're be using, you can't use a system like that. On the other hand, the fact that you're numbering tables suggests a badly formed schema. Are you sure you shouldn't merge the tables and move that number to a column inside the table ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
