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.
ps. check out,
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]