How do you create relantionships with myisam? I am trying to do many to many cause i only founded instrunctions for that relantionship from internet.
I have created now two tables and one table that only have two fields both previous tables primary keys and its primary key is both of those fields. I also made cascade for both of those fields. Well how i use that table for update query that changes will affect both of those tables or if i delete one row from one of the tables it will affect the other one also?
php+myisam(1 to many, 1 to 1,many to many)
You would need to use the InnoDB engine instead of MyISAM if you want to build in automated actions based on foreign keys. Otherwise with MyISAM you would simply have to manually code the related actions within the PHP application code (or perhaps within a stored procedure in MySQL?).