purnendu2311 Posted September 25, 2006 Share Posted September 25, 2006 Hello everybody,This is my table structure. once i select the prod_nonexclusive price or prod_nonexclusive price using radio button as prod_nonexclusive or prod_exclusivethe corresponding price should come in text box.product CREATE TABLE `product` ( `sno` int(11) NOT NULL auto_increment, `prod_id` varchar(20) NOT NULL default '', `prod_desc` text NOT NULL, `prod_type` varchar(20) NOT NULL default '', `prod_nonexclusive` double(5,0) default NULL, `prod_exclusive` double(5,0) NOT NULL default '0', `prod_colour` varchar(20) NOT NULL default '', `prod_source` varchar(50) NOT NULL default '', `prod_date` date NOT NULL default '0000-00-00', `image1_small` longblob, `image1_big` longblob, `image1_small_type` varchar(20) default NULL, `image1_big_type` varchar(20) default NULL, `image1_prod_id` varchar(20) NOT NULL default '', `image2_small` longblob, `image2_big` longblob, `image2_small_type` varchar(20) default NULL, `image2_big_type` varchar(20) default NULL, `image2_prod_id` varchar(20) NOT NULL default '', `image3_small` longblob, `image3_big` longblob, `image3_small_type` varchar(20) default NULL, `image3_big_type` varchar(20) default NULL, `image3_prod_id` varchar(20) NOT NULL default '', `image4_small` longblob, `image4_big` longblob, `image4_small_type` varchar(20) default NULL, `image4_big_type` varchar(20) default NULL, `image4_prod_id` varchar(20) NOT NULL default '', PRIMARY KEY (`prod_id`), UNIQUE KEY `sno` (`sno`), KEY `prod_colour` (`prod_colour`), CONSTRAINT `product_ibfk_1` FOREIGN KEY (`prod_colour`) REFERENCES `category` (`cat_name`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Pleaze give me solutionThanking you sirpuru Quote Link to comment Share on other sites More sharing options...
trq Posted September 25, 2006 Share Posted September 25, 2006 Post your code. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.