Ok, so I have been using Oracle before beginning to use php and mySQL and I have problems designing the mySQL back end. I have implemented the foreign keys in php by querying the "foreign key table" and inserting a record if it returns 0 and not inserting it if it doesn't. The trouble is that for complex forms this is giving me hell🙁. Same goes for varrays, I just find no alternative than to have lots of tables that I'd rather not deal with:mad:. Is there any workaround to all of this?
