[UPHPU] Table Relationships

[Dave Smith]

Webot Graphics wrote:
> What is the best way to define a relationship between two tables in 
> MySQL & PHP?
>
> I read something about needing a InnoDB, but it won't let me convert 
> my database to InnoDB because I need full text search.

Defining a relationship between two tables in MySQL has nothing to do 
PHP. Do you want a foreign key? Foreign keys make it so a field in table 
A can only have values that come from a specific field in table B. 
Here's the doc with examples:

http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html