Relationships

[phill_ridout]

how can i create one to one, one to many or many to many relationships using mysql, i have easyPHP installed, through their interface wouldbe good if poss. also can i create quierys?

[guelphdad]

read the tutorial section in the mysql manual, section #3 to familiarize yourself with using mysql.

you need to use the innodb engine type to enforce foreign keys, which is what you are talking about when it comes to relating data to data in other tables.