help SQL

[lopez65]

Someone help me with this, I want to introduce this in the SQL table accounts, but did not add anything, I've tried entering the entire table and adding it to the table, but does not create value

`flag` varchar(20) NOT NULL,

CREATE TABLE IF NOT EXISTS `znote_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `ip` int(10) NOT NULL,
  `created` int(10) NOT NULL,
  `points` int(10) DEFAULT 0,
  `cooldown` int(10) DEFAULT 0,
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `activekey` int(11) NOT NULL,
  `flag` varchar(20) NOT NULL,   <--------- HERE
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

it is for the flags of the countries look, but nothing comes out and also gives me this error in characterprofile:

Notice: Undefined variable: account_data in C:\xampp\htdocs\characterprofile.php on line 31

and this is what is written there:

<li><font class="profile_font" name="profile_font_country">Country: <?php echo '<img src="\flags\\' . $account_data['flag'] . '.png">'; ?></font></li>

if anyone can help me would be appreciated

Greetings and thanks for reading me

P.D. I use zNote last version.

 

[Codex NG]

ALTER TABLE `znote_accounts` ADD `flag` varchar(20) NOT NULL;

http://www.w3schools.com/sql/sql_alter.asp

 

[lopez65]

ALTER TABLE `znote_accounts` ADD `flag` varchar(20) NOT NULL;

http://www.w3schools.com/sql/sql_alter.asp

ok thanx, but still leave the flag and you add everything as is here https://github.com/Znote/ZnoteAAC/commit/f749d5f0f961f389961fb73d6ec647e77d7f9189,
I still dating the same mistake characterprofile, otherwise all good