I'm trying to, at the head of my script, have SQLite create a table as long as one of the same name doesn't already exist. I read the correct syntax is "CREATE TABLE IF NOT EXISTS," but when I try this, as in this example code:
<?php $db = new SQLiteDatabase("test.db"); $db->query("CREATE TABLE IF NOT EXISTS foo(id INTEGER PRIMARY KEY, name CHAR(255)"); ?>
I get the following error:
Warning: SQLiteDatabase::query() [function.SQLiteDatabase-query]: near "NOT": syntax error in test.php on line 5
What's causing this; what am I doing wrong?
I know it's gotta be something simple, but it's driving me nuts! After a few tests, I'm excited to work with this terrific database system, absolutely perfect for my application, but am stuck due to this!
Any help's much obliged!