I need add,edit, delete using php,mysql,ajax autocomplete
table sql:
CREATE TABLE IF NOT EXISTS `cus_master` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(250) NOT NULL,
`Custname` varchar(250) NOT NULL,
`address` text NOT NULL,
`place` varchar(250) NOT NULL,
`location` varchar(250) NOT NULL,
`phone` varchar(250) NOT NULL,
`mobile` varchar(250) NOT NULL,
`DLno1` varchar(250) NOT NULL,
`DLno2` varchar(250) NOT NULL,
`zipcode` varchar(250) NOT NULL,
`STno` varchar(250) NOT NULL,
`CST` varchar(250) NOT NULL,
`email` varchar(250) NOT NULL,
`DL.Exp` varchar(250) NOT NULL,
`CSTper` varchar(250) NOT NULL,
`State` varchar(250) NOT NULL,
`Tin` varchar(250) NOT NULL,
`Crlimit` varchar(250) NOT NULL,
`Cr.days` varchar(250) NOT NULL,
`Duebills` varchar(250) NOT NULL,
`Duedays` varchar(250) NOT NULL,
`int` varchar(250) NOT NULL,
`Area` varchar(250) NOT NULL,
`Rep` varchar(250) NOT NULL,
`Cust_cat` varchar(250) NOT NULL,
`bank` varchar(250) NOT NULL,
`Shipping` varchar(250) NOT NULL,
`rep_commision` varchar(250) NOT NULL,
`Rate_increase` varchar(250) NOT NULL,
`Currency` varchar(250) NOT NULL,
`CrDisc` varchar(250) NOT NULL,
`CashDisc` varchar(250) NOT NULL,
`Grade` varchar(250) NOT NULL,
`Allow_billing` varchar(250) NOT NULL,
`Allow_product_disc` varchar(250) NOT NULL,
`Type` varchar(250) NOT NULL,
`Active` varchar(250) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;