I've looked at the phpmyadmin editing on the grid, and that would do - in a pinch.
Problems with that are that I have to search for the record, it may not be on the current page so I have to page through to find it, and setting the number of records on one page to 500 times out - I have over 800 records and I need to search by a bowl name, not my the index number (I may not have that if I am looking at a bowl and need to change/add some text to one or more fields). For instance, in the past I may have entered the new record with just the bowl name and perhaps the source wood it was made from - but not a description if it wasn't finished yet with the leather, carving, air brush work I add later. At that time, I did not record the index because I don't need it yet...
The result is, searching for the name isn't the fastest way to go - and yes, I can sort the list, but it's still a nuisance when dealing with many bowls.
It also requires shifting right/left to find the field, more time - and then when I click to edit the field the text is in a small box, and a bit hard for me to read.
I looked at MySQL Workbench - it would work, but is a bit more than what I want - and costs after the trial is done.
Anyway, I found one script that does some of what I need http://www.tutorialspoint.com/php/mysql_update_php.htm
, a simple editor that allows changing a field using an input box, but it won't load the existing data, which I want to see so I can tell which of the 14 fields I need to change.
I have finished most of a script that allows me to enter a bowl name, it calls the record for that and shows a page with the fields with existing data - on submit it will open the record and update the entire record.
I have this done up to the point of the update - having some problem coding the actual update code for the 14 fields:
intProductID -------this is the index, so probably should not update this...
into the tblSplintersBowlInventory table.
The examples of the UPDATE function seem to say I have to update each separately - is this true, or can I do it in a single query, similar to the INSERT function?