I have this table. THE TABLE IS POPULATED WITH DATA. And the model is InspectionMapping
CREATE TABLE `inspection_mapping` (
`inspection_mapping_id` bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`building_id` int(11) NOT NULL DEFAULT '0',
`tariff_id` int(11) NOT NULL DEFAULT '0',
`fee_id` int(11) NOT NULL DEFAULT '0',
`company_id` int(11) NOT NULL DEFAULT '0',
`zone_id` int(11) NOT NULL DEFAULT '0',
`is_mapped_to_zone` tinyint(1) NOT NULL DEFAULT '0',
`is_inspected` tinyint(1) NOT NULL DEFAULT '0',
`is_paid` tinyint(1) NOT NULL DEFAULT '0',
`is_booked` tinyint(1) NOT NULL DEFAULT '0',
`is_mapped_to_inspector` tinyint(1) DEFAULT '0',
`mapping_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
I want to create a gridview that loads the data from it where zone_id = 1, and order by building_id. Then on the click of the submitbutton, is_mapped_to_inspector should be set to 1.
Please help me out