Hey everyone :-)
This is my first post to the list and I would like to thank everyone for
this great resource. I'm relatively new to mySQL and a novice at PHP, but
here is a description of what I am trying to do. My objective is to create
a database that will provide variables for a series of forms. These
variables would be conditional based on a few series of simple drop down
menu based questions.
Here is a particular sequence;
1st)" What era of military is this roster for?"
a) Modern
b) WWI/WWII
Based on a)'s choice they would get this list of variables to choose from;
Spanish Marines:
Japanese Military:
US Airforce:
US Army:
US Marines:
US Navy:
Based on b)'s choice they would get this list of variables to choose from;
WW2 British Army:
WW2 G-Kreigsmarine:
WW2 G-Luftwaffe:
WW2 G-Waffen-SS:
WW2 G-Wehrmacht:
WW2 Red Army AirForce:
WW2 Royal Air Force:
WW2 Royal Navy:
WW2 US Army AirForce:
WW2 US Army:
WW2 US Navy:
Now for any of these choices I have a list of associated ranks which
depending on which choice is made could be as little as 20 but as many as
30 variables to choose from. For example, here is a list of equal world
ranks based on the U.S. equivalent of (E-1) or standard "enlisted" men.
ENLISTED
PRIVATES (E-1)
Private
Spanish Marines: Soldado
Japanese Military: Nitto Hei
US Airforce: Airman Basic
US Army: Private (E-1)
US Marines: Private
US Navy: Seaman Recruit
WW2 British Army: Private or Sapper
WW2 G-Kreigsmarine: Matrosengefrieter
WW2 G-Luftwaffe: Flieger or Gefrieter
WW2 G-Waffen-SS: SS-Schutze
WW2 G-Wehrmacht: Schutze (after Nov. 1942: Grenadier)
WW2 Red Army AirForce: Krasnoarmeyets
WW2 Royal Air Force: Aircraftsman 2nd Class
WW2 Royal Navy: Ordinary Seaman
WW2 US Army AirForce: Private
WW2 US Army: Private
WW2 US Navy: Seaman Recruit
So, as you can see that there is a lot of menu driven choices and this is
only one tier of ranks of 25 or 30 that must be created. Plus I have an
image directory with all the associated ribbons for each of these ranks on
each level. For that though I will refer to the directory where the image
resides rather then dragging the speed of the DB down to call on the
images. Having never created a database of this size I am looking for some
guidance/help on what might be a way to best approach or someway to get the
info in by batching a CSV file or something like that.
ENLISTED
PRIVATES (E-1)
Private
Spanish Marines: Soldado
Japanese Military: Nitto Hei
US Airforce: Airman Basic
US Army: Private (E-1)
US Marines: Private
US Navy: Seaman Recruit
WW2 British Army: Private or Sapper
WW2 G-Kreigsmarine: Matrosengefrieter
WW2 G-Luftwaffe: Flieger or Gefrieter
WW2 G-Waffen-SS: SS-Schutze
WW2 G-Wehrmacht: Schutze (after Nov. 1942: Grenadier)
WW2 Red Army AirForce: Krasnoarmeyets
WW2 Royal Air Force: Aircraftsman 2nd Class
WW2 Royal Navy: Ordinary Seaman
WW2 US Army AirForce: Private
WW2 US Army: Private
WW2 US Navy: Seaman Recruit
I have a few resellers accounts and would be willing trade some
web-space/bandwidth for some direct help on this. Please email me direct if
can give some time to this.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
