Entering Data Into A Bridge Table (With php?)

[Babs Patel]

I'm new to database design, but I understand the basics of MySQL and php.

To make a simple music database in MySQL, I've made a table of songs
(song) and a table of
players (player) joined by a bridge table (song_play) to allow
many-to-many
relationships.. .eg:

create table song
(song_id int primary key,
name char(30));

create table player
(player_id int primary key,
name char(30));

create table song_play
(song_id int not null,
player_id int not null,
primary key(song_id, player_id));

Once the names of songs and players are entered into their respective
tables, is there a way to use php to enter data into the join table other
than manually looking up the id's from song and player and entering those
into song_play?

Thanks,

Babs

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

[Geoff Berrow]

Re: Entering Data Into A Bridge Table (With php?)

I noticed that Message-ID: <oprynnxazarz6b v7@news.west.co x.net> from
Babs Patel contained the following:
[color=blue]
>Once the names of songs and players are entered into their respective
>tables, is there a way to use php to enter data into the join table other
>than manually looking up the id's from song and player and entering those
>into song_play?[/color]

Query the database and use the results to populate something like drop
down boxes. On Submit the selections add a row to the join table.
However this could get really unweildy with large numbers of
songs/artists so you have to add some criteria to the initial query.

In practice though, would you not be doing this when you added new
songs? Something like:

Enter song
insert record into song table
enter player
If player exists, display player details
else prompt to enter player details and then insert record into artist
table.
Display player details
insert record into song_play table

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/