redbread211

the question is there ...... can it be done can the input from the user be checked to see if say Attack is a certain total and place the info in the right catagoryIEif attack is 10300 then the info will be placed in the main database and in Alpha

1. i am a complete noob to complicated data handling i can do straight data access and input but here im stumped i am using mysql latest version
2. i have 4 criteria
3. Name
4. Level
5. Attack Skill
6. Defense Skill
7. these are the user input
8. then i have 5 squads
10. Praefecti Praetorio (20000)
11. Praetorian Guards (15000-19999)
12. alpha (10000-14999)
13. bravo (7500-9999)
14. charlie (5000-7499)
15. probation and training (below 5000)
17. each squad requires a certain attack skill ...in brackets above...so as the user inputs there data it needs to be put in the right catagory or squad can this be done ......the output will have just the users name under the right squad heading