[SOLVED] Database problem!!!

[rameshfaj]

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!!!

 

[fenway]

What do you mean "everyone in the table is affected"? Like a trigger?

[teng84]

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

[rameshfaj]

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.

[fenway]

How are you inserting/updating? Post the relevant code... but I still don't understand what you mean.

[rameshfaj]

Sorry for annoyance, but I have found the solution.

 

Thanks everybody for the co-operation!

[fenway]

Sorry for annoyance, but I have found the solution.

 

Thanks everybody for the co-operation!

The only annoyance is not posting said solution.