You could say I bit off more than I could chew... However, what's done is done and I'm pulling the rest of my hair out and looking to the DaniWeb community for help...
I am building a site that people can log in to and select classes that are owned by different users...
I have 7 tables in my DB
CREATE TABLE `Class` ( `CID` int(10) NOT NULL auto_increment, `CDID` int(10) NOT NULL, `OID` int(10) NOT NULL, `CDName` varchar(255) NOT NULL, PRIMARY KEY (`CID`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
I have a ton of questions, but, I'll only ask a few... I'm sure I can figure it out with a little direction...
1. How do I apply Foreign keys to tables? If I do, can I update the ClassDetails table and auto populate the Class tables at the same time? When I try to add the Foreign Key now I get "No Index Defined!"...
2. Once the relationship is made using CASCADE can I update one to many rows?
Any help would be great!