Re: One to Many Relationships in MySQL with PHP

[Thomas Ljungstrom]

Hi!

In MySQL you don´t create an relation. You do it every time in your sql-statements with JOIN.
Make sure that your table Wrote have a primary id of both BookNum AND AuthorNum

CREATE TABLE `wrote` (
`booknum` int(11) NOT NULL default '0',
`authornum` int(11) NOT NULL default '0',
PRIMARY KEY (`booknum`,`authornum`)
) TYPE=MyISAM;