Jump to content
MakeWebGames

QUERY ERROR


Paddy

Recommended Posts

Don't know if this is the right place to put it

but i was wondering if any one could help me out with this query since i don't quite understand these things but i learn very quickly!

QUERY ERROR: Unknown column 'attacks_won' in 'field list'

Query was UPDATE users SET attacks_won=attacks_won+1 WHERE userid=1

i guess you know where this has shown up

''just after wining a fight''

Thanks In advanced

Link to comment
Share on other sites

Guest Anonymous

Re: QUERY ERROR

Looks like you need to add the column "attacks_won" to the users table:

 

ALTER TABLE `users` ADD `attacks_won` INT UNSIGNED NOT NULL DEFAULT '0';
Link to comment
Share on other sites

Guest Anonymous

Re: QUERY ERROR

Hmm, odd - PM me the structure of your users table (phpMyAdmin - Export - **NO DATA**)... I'm curious about this..

Might be an idea to post a snippet of the code as well - 10 or so lines either side of the line containing the error.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...