rameshfaj Posted August 6, 2007 Share Posted August 6, 2007 I have the database described in mysql. In one of the tables,if i insert new item or update entry of some item then everyone in the table are affected.Is there any case that can make this. CREATE TABLE `item` ( `id` bigint(20) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` varchar(255) default NULL, `price` float default NULL, `categoryid` bigint(20) default NULL, `picture` varchar(255) default NULL, `date` date NOT NULL default '0000-00-00', `ccid` varchar(255) default NULL, `contact` varchar(255) default NULL, `status` enum('Available','Requested','Sold') default 'Available', PRIMARY KEY (`id`), KEY `description_2` (`description`), ) TYPE=MyISAM AUTO_INCREMENT=16 ; All this code is generated by the PHPMyAdmin of easyphp 1-7. Any suggestions are welcome!!! Quote Link to comment https://forums.phpfreaks.com/topic/63512-solved-database-problem/ Share on other sites More sharing options...
fenway Posted August 10, 2007 Share Posted August 10, 2007 What do you mean "everyone in the table is affected"? Like a trigger? Quote Link to comment https://forums.phpfreaks.com/topic/63512-solved-database-problem/#findComment-320235 Share on other sites More sharing options...
teng84 Posted August 10, 2007 Share Posted August 10, 2007 What do you mean "everyone in the table is affected"? Like a trigger? yahhh what do you mean reading your post seems like a one - many relationship is that what you mean Quote Link to comment https://forums.phpfreaks.com/topic/63512-solved-database-problem/#findComment-320776 Share on other sites More sharing options...
rameshfaj Posted January 18, 2008 Author Share Posted January 18, 2008 I meant to say that when info about one item is updated or new entry is entered in the table, then the info about already existing item is also changed. For what reason this incident is happening to the table? I am unable to identify. Can there be any such case or is this the problem of the database server?Plz inform me. Quote Link to comment https://forums.phpfreaks.com/topic/63512-solved-database-problem/#findComment-442493 Share on other sites More sharing options...
fenway Posted January 18, 2008 Share Posted January 18, 2008 How are you inserting/updating? Post the relevant code... but I still don't understand what you mean. Quote Link to comment https://forums.phpfreaks.com/topic/63512-solved-database-problem/#findComment-442791 Share on other sites More sharing options...
rameshfaj Posted January 23, 2008 Author Share Posted January 23, 2008 Sorry for annoyance, but I have found the solution. Thanks everybody for the co-operation! Quote Link to comment https://forums.phpfreaks.com/topic/63512-solved-database-problem/#findComment-446779 Share on other sites More sharing options...
fenway Posted January 23, 2008 Share Posted January 23, 2008 Sorry for annoyance, but I have found the solution. Thanks everybody for the co-operation! The only annoyance is not posting said solution. Quote Link to comment https://forums.phpfreaks.com/topic/63512-solved-database-problem/#findComment-447257 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.