sqlite query with "@" throwing errors
Posted: Fri Feb 02, 2007 6:25 am
I am migrating my forums to another forum script and also from mysql to sqlite....
this code returns errors on the sqlite query line
Warning: sqlite_query() [function.sqlite-query]: unrecognized token: "@" in ...
what am i missing here?
this code returns errors on the sqlite query line
Code: Select all
$sql_get_users ="SELECT user_id,username,`password`,email,posts,date_added FROM phorum_users WHERE active=1 AND user_id > 2";
$result_users = mysql_query($sql_get_users);
$sql_insert_users = array();
while ($row = mysql_fetch_assoc($result_users)){
$sql_insert_users[]="INSERT INTO users (id,username,password, email,num_posts,registered) VALUES
(".$row["user_id"].",".$row["username"].",".$row["password"].",".$row["email"].",".$row["posts"].",".$row["date_added"].")";
}
foreach ($sql_insert_users as $iterador){
$iterador = sqlite_escape_string($iterador);
echo $iterador."<br />";
sqlite_query ( $db, $iterador );
}Warning: sqlite_query() [function.sqlite-query]: unrecognized token: "@" in ...
what am i missing here?