I have a database with some of the fields on some of the product records that are empty.
I would like to find an existing editor that allows me to call up any individual record, and show me what is in that record.
An editor that can look at a MySQL database, show the existing data in the fields, and allow me to enter/change data into any of the fields.
PhpMyAdmin does this, but I have to select each record from the screen, click to edit it, then go to another form to make changes. Plus, long text fields need to be scrolled in a small box that does not show the entire text.
The ideal form would allow me to enter the product name, and it would use that to pull just the record for that product, and allow me to enter text in any field, then save it into the database, replacing the existing record.
I can write a form that will allow me to enter data in the fields, and use PHP to replace the existing record - but that would not show me the existing data in those fields before I make the changes. I want to call a record, see what is in it, then make changes as needed.
Thanks.
Edit to add that I do NOT want to be able to change the table structure of the database, just simply edit the data and fill in missing data.