Re: [PHP-DB] composite keys

>Hi all: >I am using php4.0.3pl1 with MySQL 3.22.32 on Apache for RH Linux. > >I have a table/relation of sports, where amongst other categories, are >teams, where there can be many 'teamNames' & 'teamInfos' for one sport. > >The problem here is that without the use of a composite key: >'sportName

Re: [PHP-DB] composite keys

TECTED]> Para: <[EMAIL PROTECTED]> Enviada em: segunda-feira, 19 de fevereiro de 2001 11:21 Assunto: [PHP-DB] composite keys > Hi all: > I am using php4.0.3pl1 with MySQL 3.22.32 on Apache for RH Linux. > > I have a table/relation of sports, where amongst other categories, ar

Re: [PHP-DB] composite keys

Russ: 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 sport, just with a query select * from players where team = t?, sport=? no need for compos

[PHP-DB] composite keys

Hi all: I am using php4.0.3pl1 with MySQL 3.22.32 on Apache for RH Linux. I have a table/relation of sports, where amongst other categories, are teams, where there can be many 'teamNames' & 'teamInfos' for one sport. The problem here is that without the use of a composite key: 'sportName' & 'T