Hey all,
How do I set up relationships. I have two tables, memberinfo and personalinfo and they both have an id coloumn. I want to link the id columns together to make sure that the right member row is connected to the right personal row.
Thanks. Jack.
Which database are you using? MySQL simply ignores any attempt at creating a referential integrity rule, unless you're using InnoDB tables. (see this).
MySql, should I just use php to do this? It is a long way roudn but I can do it.
There was a thread earlier about this exact issue. Regardless, you could use MySQL with InnoDB tables and have it enforce foreign key relationships.
Otherwise, you have no other option but to implement it in PHP.
