Solved Query code

[Famex]

Hey, I'm new to this, anyone know how to fix?

mysql_real_query(): SELECT 1 FROM accounts WHERE id=1905 AND rewarded='1' LIMIT 1 - MYSQL ERROR: Unknown column 'rewarded' in 'where clause' (1054)
mysql_real_query(): UPDATE `accounts` SET `premium_points` = `premium_points` + 3, rewarded='1' WHERE id=1905 - MYSQL ERROR: Unknown column 'rewarded' in 'field list' (1054)

`rewarded` enum('0','1') NOT NULL DEFAULT '0',

tried with ^, but wont work

 

[Famex]

@Limos
bump

 

[Ninja]

Unknown column so you need to alter the table accounts.

ALTER TABLE `accounts` ADD `rewarded` INT (11) NOT NULL DEFAULT 0;

 

[Thormer]

Thanks Ninja