[SOLVED] INSERT into ... WHERE ...

[YourNameHere]

This is a stupid easy one but cant for the life of me find the solution.

 

I have a table that holds an ID and 6 empty columns for later use.

 

when I try and select the right id and then populate 1 or more of the empty columns I get a syntax error.

 

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 'WHERE chatId =  'Chat_1257295904'' at line 1

 

here is the statement:

 

INSERT into invites (player1) values ('Cody') WHERE chatId = 'Chat_1257295904'

 

this is how the table is set up:

 

columns; chatId, player1 - player6

[smerny]

what type is chatId?

[xtopolis]

In the way you describe your setup, shouldn't you be using an update instead?

UPDATE invites SET player1 = 'Cody' WHERE chatId = 'Chat_1257295904'';

 

It doesn't seem like the string "Cody" is stored in another table by the way you described it.

[YourNameHere]

You're probubly right about an update being correct. and Cody is stored elsewhere in another table, it's a username.

 

chatId is varchar(40)

 

it stores "chat_16516579" where the numbers are the timestamp when the chat was created.

[smerny]

if i were you i'd use an auto increment primary id for the chatId.... and if you wanna store a time, use another column

 

anyway, did you switch to update? if so show the surrounding code so we can see the quotes used and such

[YourNameHere]

Yes I switched to update and it worked. thanks.

 

The time is just there to make it unique.