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/