Syntax Error using SQLite

[cms07]

Hey guys. I'm inserting some stuff into an SQLite database.
Here's the error I'm getting:

Warning: sqlite_query() [function.sqlite-query]: near ",": syntax error in C:\wamp\www\sqlite\cms\install.php on line 54

and here's the line

Code: [Select]

sqlite_query($con, "INSERT INTO ".$s_dbprefix."_setting (variable, value) VALUES('siteurl','$s_url'),('sitename','$s_name'),('adminemail','$s_email')", null, $query_error);Any ideas?

[Ian]

SQLite doesn't support extended (multiple rows at once) inserts.

[cms07]

SQLite doesn't support extended (multiple rows at once) inserts.

Oh. Well then.
Thanks aldo.

[cms07]

It's time for round two.
Warning: sqlite_query() [function.sqlite-query]: near "group": syntax error in C:\wamp\www\sqlite\cms\install.php on line 61

[/code]sqlite_query($con, "CREATE TABLE ".$s_dbprefix."_user (id auto_increment PRIMARY KEY,name VARCHAR(25),password VARCHAR(25),regdate INT,email BLOB,gender VARCHAR(10),ip BLOB,group SMALLINT)", null, $query_error);

Code: [Select]

Is there anything fundamental I'm doing wrong?

[Ian]

Kinda need the query in order to be of any help...

[soren121]

SMALLINT isn't an acceptable datatype in SQLite 2.

[Ian]

I think it is, actually. I remember using it, maybe (haven't touched SQLite in forever).

If I remember right, SQLite doesn't give a rats you know what... If the type doesn't exist, it treats it as a string... The only strongly typed, well type, in SQLite 2 is INTEGER.