Mysql query syntax error problem

[tfe]

Hello,

 

What's wrong in this query? It returns syntax error.

$result = mysql_query("INSERT INTO messages_folders(id,recipient,sender,number,updated,title) 
VALUES ('" . implode(',',$folders) . "') ON duplicate KEY UPDATE number=number+1") or die(mysql_error());

 

Thanks.

[xyph]

MySQL error or PHP error?

[tfe]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10618','60', '1', '1309958664', 'test')') ON duplicate KEY UPDATE number=num' at line 1

 

[xyph]

You should start by echoing your query.

[tfe]

Changed query to:

 

$result = mysql_query("INSERT INTO messages_folders(id,recipient,sender,number,updated,title) 
VALUES (".implode(",", $folders).") ON duplicate KEY UPDATE number=number+1") or die(mysql_error());

 

Now I am getting another error:

 

Column count doesn't match value count at row 1

 

Don't know how is it possible if $folder value count is the same:

 

array_push($folders, "(NULL,'$tid','$id','1','$timestamp','$name')");

 

Maybe I need to open another thread. Actually I am looking for solution how to send/delete multiple mssages at the same time (with implode) and then to update number of messages for each folder. Updating doesn't work correctly if I use "implode". 

[xyph]

You want to echo out the query. You'll see what's going wrong.

[tfe]

Here is the echo result:

 

INSERT INTO messages_folders(id,recipient,sender,number,updated,title) VALUES ((NULL,'10618','60','1','1309962951','test')) ON duplicate KEY UPDATE number=number+1

 

I don't see any problem but this query still returns error: "Column count doesn't match value count at row 1"

[xyph]

Double parenthesis.

 

It's treating your second set of brackets as a single column, I think

[tfe]

Ohh, thank you very much. It's OK now.