here is my table
CREATE TABLE `invoice` (
`invoice_id` tinyint(4) NOT NULL auto_increment,
`company_name` varchar(255) NOT NULL,
`issue_date` int(11) NOT NULL,
`invoice_title` varchar(255) NOT NULL,
`country` varchar(255) NOT NULL,
`invoice_number` int(20) unsigned NOT NULL,
`payment_method` varchar(255) NOT NULL,
`payment_due_date` int(11) NOT NULL,
`payment_plan` varchar(255) NOT NULL,
`paid` int(5) unsigned NOT NULL,
`paid_date` int(11) NOT NULL,
`added_date` int(11) NOT NULL,
`modified_date` int(11) NOT NULL,
PRIMARY KEY (`invoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
please tell the query so that when i click edit for corresponding invoice_id should get updated by retreiving the corresponding invoice_id im able to get the corresponding values for editing but not able to update please pass me the query for the above table
thanks in advance