Data getting dropped

[rfigley]

Have a database where when more than one peron is updating info at the same time. One of the tables is dropping records. Can lack of normalization cause this if there is no joins being used? But rather the tables being accessed separately?

[jweissig]

hi,

what type of information is being dropped and how do you think this is happening? For example can you please show some examples of the data and table design.

You might want to take a look at transactions if your database supports them or you can take a look into locking tables/rows that you want to update or add.

thanks
- justin

[rfigley]

This is the table (called "Chapters") that is dropping records
This is being updated with "update" only.
This is also being queried for reference in updating "Members" table (see code below)

chapter_ID int(5) UNSIGNED ZEROFILL No auto_increment

county varchar(30) No

chapter_name varchar(40) No

lunch_breakfast varchar(15) No

location varchar(80) No

time varchar(20) No

day varchar(12) No

director varchar(40) No

members_link varchar(30) No

president varchar(30) No

president_number varchar(20) No

This table is called "Members"
Table being updated with "update" and/or "insert"

members_ID int(5) UNSIGNED ZEROFILL No auto_increment

name varchar(40) No

chapter varchar(30) No

position varchar(20) No

category varchar(50) No

business_name varchar(40) No

address1 varchar(40) No

address2 varchar(40) No

city varchar(20) No

state char(2) No

zip varchar(5) No

phone varchar(12) No

ext varchar(7) No

cell_phone varchar(12) No

fax varchar(12) No

email varchar(40) No

web_address varchar(40) No

member_since varchar(5) No