check from 2 tables and then enter to the database

[avraamG13]

Hello again,

 

Lets say i have 2 diferent tables,

 

players:

id_player

name_player

 

players_selections_cat:

id_player

positions

 

I have a form that will submit in table 'players_selections_cat' some info, but i want to check from table 'players' row 'id_player' (this has ONLY numbers) if the 'id_player' is on the database to enter the info i want or else show a message that the info im trying to enter is not exist in the database

 

I hope you understant

 

Thank you

[Ken2k7]

SELECT `id_player`
FROM `players`
WHERE `id_player` = '$some_id'
LIMIT 1