Windows How can I get rid of this mysql_real_query

[snipermike13]

[09/06/2010 14:22:18] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)

This annoys me because it is the only one that pops up under when it says server loaded and I am trying to fix the errors above it and every 30 seconds this pops up and makes it go to the bottom again....VERY ANNOYING.

HELP!?!?!

Rep+

 

[president vankk]

UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1

 

[chojrak]

UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1

U're wrong.

@TOP:

ALTER TABLE `players` ADD `onlinetimetoday` INT(10);

 

[snipermike13]

so simple yet such a pain in the ass lol, you taught me how to fix these types of errors now. Thank you :0

Rep+

 

[LucasFerraz]

Same to me, can some1 help?


mysql_real_query(): SELECT `name`, `password`, `salt`, `premdays`, `lastday`, `key`, `warnings` FROM `Accounts` WHERE `id` = 1 LIMIT = 1 - MYSQL ERROR: Unknow Column ´salt´ in ´field list´ (1054)
mysql_real_query(): SELECT `name`, `password`, `salt`, `premdays`, `lastday`, `key`, `warnings` FROM `Accounts` WHERE `id` = 6159667 LIMIT = 1 - MYSQL ERROR: Unknow Column ´salt´ in ´field list´ (1054)