[UPHPU] Table Relationships

[Webot Graphics]

But like I said if I go to InnoDB I can't use full text search. Is  
there a way around that? Maybe with PHP?

Justin Giboney
Graphic Design
Western Botanicals
Ph:800.651.4372, Fax:866.366.4372


On Apr 5, 2007, at 4:26 PM, Dave Smith wrote:

> 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
>