check mysqfields and do something if the requirements is the same

[anthelo]

Hello,

 

im having a table 'requirements' with rows

- Age (17,18,19,20,21,22,23,24,25+)

- Keeper (Number 1 - 20)

- Playmaker (Number 1 - 20)

- Scorer (Number 1 - 20)

- Winger (Number 1 - 20)

- Defender (Number 1 - 20)

- id (1 for one country 2 for other country)

 

I want to check when a player is in the age {Age row} and {id row} is the same and then check the rest of the fields if its the same or better than the number i have on mysql do something

 

 

Thank you