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]