Thanks for your help... Here are the aplicable tables... I don't know how to get you some sample data, because I think the problems only exists on the clients that have a lot of targets... so I would have to almost give you all of the data. I don't mind doing that, but if I do, I want to do it on a more secure platform than uploading to the post because it is fairly sensitive info. Let me know... Thanks again, Dan
TABLE target (
targetID int(11) NOT NULL auto_increment,
targetEnteredDate varchar(8) NOT NULL default '0',
targetEmail varchar(50) default NULL,
targetFirstName text NOT NULL,
targetLastName text,
targetStreetAddress varchar(50) default NULL,
targetCity text,
targetState text,
targetZip varchar(11) default '0',
targetFirstTimeCustomer text NOT NULL,
targetBirthday1 varchar(4) default NULL,
targetBirthday1Name text,
targetBirthday2 varchar(4) default NULL,
targetBirthday2Name text,
targetBirthday3 varchar(4) default NULL,
targetBirthday3Name text,
targetBirthday4 varchar(4) default NULL,
targetBirthday4Name text NOT NULL,
targetBirthday5 varchar(4) default NULL,
targetBirthday5Name text NOT NULL,
targetAnniversary varchar(4) default NULL,
clientID int(11) NOT NULL default '0',
targetAdType text,
targetSpecialInterest1 text,
targetSpecialInterest2 text,
targetSpecialInterest3 text,
targetSpecialInterest4 text,
targetSpecialInterest5 text,
targetSpecialInterest6 text,
targetOther1 text,
targetOther2 text,
targetBillAmount int(11) default NULL,
targetServer varchar(25) default NULL,
targetFTEmailSent char(1) default NULL,
repID int(11) NOT NULL default '0',
PRIMARY KEY (targetID),
KEY clientID (clientID)
) TYPE=MyISAM;
TABLE client (
clientID int(11) NOT NULL auto_increment,
clientStatus text NOT NULL,
clientName varchar(50) NOT NULL default '',
clientEmail varchar(100) NOT NULL default '',
clientWeb varchar(50) NOT NULL default '',
clientCommentsClick varchar(100) NOT NULL default '',
clientPhone varchar(20) NOT NULL default '0',
clientSlogan text NOT NULL,
clientMaxEntries int(11) NOT NULL default '0',
clientEmailService text NOT NULL,
clientDirectMailService text NOT NULL,
clientSignatureFile varchar(50) default 'defaultSignature.gif',
clientSignatureFile2 varchar(50) default 'defaultSignature.gif',
clientSalutation text NOT NULL,
clientOwnerName text NOT NULL,
clientOwnerTitle text NOT NULL,
clientOwnerName2 text NOT NULL,
clientOwnerTitle2 text NOT NULL,
clientOfferExpire int(11) NOT NULL default '0',
clientFPBack text NOT NULL,
clientTileBack text,
clientBirthdayBorder text NOT NULL,
clientBirthdayImage text,
clientTopLeftBirthday text NOT NULL,
clientTopRightBirthday text NOT NULL,
clientBirthdayText text NOT NULL,
clientBirthdayTerms text NOT NULL,
clientFirstTimeCustomerText text NOT NULL,
clientFTterms text NOT NULL,
clientLogo text NOT NULL,
clientTopLeft text NOT NULL,
clientTopRight text NOT NULL,
clientAnniversaryBorder text NOT NULL,
clientAnniversaryImage text,
clientTopLeftAnniversary text NOT NULL,
clientTopRightAnniversary text NOT NULL,
clientAnniversaryText text NOT NULL,
clientAnniversaryTerms text NOT NULL,
clientSEFullTitle text NOT NULL,
clientSEFull text,
clientSpecialInterest1 text NOT NULL,
clientSpecialInterest1Logo text NOT NULL,
clientSpecialInterest1Border text NOT NULL,
clientSpecialInterest1UseFP text NOT NULL,
clientSpecialInterest1Text text NOT NULL,
clientSpecialInterest2 text NOT NULL,
clientSpecialInterest2Logo text NOT NULL,
clientSpecialInterest2Border text NOT NULL,
clientSpecialInterest2UseFP text NOT NULL,
clientSpecialInterest2Text text NOT NULL,
clientSpecialInterest3 text NOT NULL,
clientSpecialInterest3Logo text NOT NULL,
clientSpecialInterest3Border text NOT NULL,
clientSpecialInterest3UseFP text NOT NULL,
clientSpecialInterest3Text text NOT NULL,
clientSpecialInterest4 text NOT NULL,
clientSpecialInterest4Logo text NOT NULL,
clientSpecialInterest4Border text NOT NULL,
clientSpecialInterest4UseFP text NOT NULL,
clientSpecialInterest4Text text NOT NULL,
clientSpecialInterest5 text NOT NULL,
clientSpecialInterest5Logo text NOT NULL,
clientSpecialInterest5Border text NOT NULL,
clientSpecialInterest5UseFP text NOT NULL,
clientSpecialInterest5Text text NOT NULL,
clientSpecialInterest6 text NOT NULL,
clientSpecialInterest6Logo text NOT NULL,
clientSpecialInterest6Border text NOT NULL,
clientSpecialInterest6UseFP text NOT NULL,
clientSpecialInterest6Text text NOT NULL,
clientOther1 text NOT NULL,
clientOther2 text NOT NULL,
clientSpecialEvent1 text,
clientSpecialEvent1Logo text,
clientSpecialEvent1Border text,
clientSpecialEvent1UseFP text,
clientSpecialEvent1Text text NOT NULL,
clientSpecialEvent2 text,
clientSpecialEvent2Logo text,
clientSpecialEvent2Border text,
clientSpecialEvent2UseFP text,
clientSpecialEvent2Text text NOT NULL,
clientSpecialEvent3 text,
clientSpecialEvent3Logo text,
clientSpecialEvent3Border text,
clientSpecialEvent3UseFP text,
clientSpecialEvent3Text text NOT NULL,
clientSpecialEvent4 text,
clientSpecialEvent4Logo text,
clientSpecialEvent4Border text,
clientSpecialEvent4UseFP text,
clientSpecialEvent4Text text NOT NULL,
clientSpecialEvent5 text,
clientSpecialEvent5Logo text,
clientSpecialEvent5Border text,
clientSpecialEvent5UseFP text,
clientSpecialEvent5Text text NOT NULL,
clientSpecialEvent6 text,
clientSpecialEvent6Logo text,
clientSpecialEvent6Border text,
clientSpecialEvent6UseFP text,
clientSpecialEvent6Text text NOT NULL,
PRIMARY KEY (clientID),
UNIQUE KEY clientName (clientName)
) TYPE=MyISAM;