Keep an independent key, for instance a field called ID,
with auto-counter. That will make your rows uniquely identified...
then if you want to search for a player in a specific team, and a specific
just  with  a query select * from players where team = t?, sport=?
no need for composite keys, Indeed not recommended.

Lennin Arriola

ps. check out,

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to