Help Mysql Checkbox! I'm crazy...

[artvor]

Hi all,

I'm going crazy...

I need make this simple function:

I need to have 2 inputs checkboxes Bank wire and visa.

How can i update them?

Here is my VISA table (the bank_wire is almost equel to visa table)

CREATE TABLE IF NOT EXISTS `visa` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `method_name` char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Visa',
  `checked` smallint(1) unsigned NOT NULL DEFAULT '1',
  `commision` char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No commisions',
  `proccess_time` char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Instant',
  `min_deposit` char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '100 USD',
  `max_deposit` char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No limits',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dump dei dati per la tabella `visa`
--

INSERT INTO `visa` (`id`, `method_name`, `checked`, `commision`, `proccess_time`, `min_deposit`, `max_deposit`) VALUES
(1, 'Visa', 1, '2%', 'Instant', '100 USD', '7000 USD every 7 days');

So when user click on checkbox the value "checked" in the table have to becoum =1 and if it's not checked it's must be =0

I need a html code + mysql code ( mysql_query("UPDATE ....))

Thanks to all..

[artvor]

Any help?