Hi Everyone,
I've inherited an MySQL MyISAM database which has data about instructors stored across two tables. I need to create an editor for it and I’d like to use phpMyEdit as I’ve used it so many times before (it is great).
Unfortunately I can’t merge the two tables as there is a huge amount of legacy PHP code that uses it the way it is. I’ve no idea why they didn’t just have a single table, as the rows from each table are simply linked via a “membership number” field (a code, not an ID which is another problem with this database).
What I need to present to the user is one editor that allows them to edit rows stored across these two tables. I’ve created a “view” in MySQL and phpMyEdit happily displays it, but of course it can’t save the data back into the view.
I’ve been pulling my hair out for days with this problem. Any help would be really appreciated.
Kind Regards
Neil
|
Prihlásiť
Registrácia
English
