Re: Contact Database php_mysql

Wow I'm amazed and thankful for such help and advice I thought I would attack this project piecemeal but that will not give a clear view that will allow helpful comment without the full view. I have a website at http://geocities.com/efoxfiles a labor of love So now it has become so detail intensive that I want to expand the scope to include all field sports with a Hunting...Foxhunting, Tree hunting Shooting Sports, Arena Sports...rodeos, horse events, 4H, all linking to Contact table Pedigrees...Hound,Whelping Date, Sire, Dam, Owner, Breeder... links to Contact Table/zip/city/state/address Timeline...back to Origin of each sport....all linking to Contact Table Field Trial and Show Associations ...linking to Contact table So I did not present the true picture as I was assuming that I could piggyback all the tips and replicate them into a complete database. Practically all cities and zip codes may have to be in linking tables and the ID used in each category....So I know just enough to get me in trouble. So reflecting what advice I have received to date: [Sportsmen] name to be registered of www ContactID FirstN,MidN,LastN,Suffix,Cityid,Stateid,Zip_Codepk,Addr1,Addr2,Other Cityid pk CityName Stateid pk Statename Assnid Assn (Associations) Trials/Showsid Trials/Show Houndsid Registry# /*Date to be a Timestamp?...reflecting yyyymmdd001 to infinity refecting how many hounds born on that date*/ IFSB# SFSB# UKC# AKC# Whelping Date /*Is there such a thing as Dateid (linking table)*/ Sire (houndid) Dam (houndid) Owner (contactid) Breeder (contactid) Colorid (20+ color combinations) /*I have developed a CSS file that will display hound names in a heirarchial display to display a pedigree. My hope is to be able to use only the Sireid and Damid to present 5 generations???*/ /*I will have a large server thus excess capacity, php, mysql, pop3, mailing lists...maybe I can reward some of my helpers down the road*/ Russell Griechen