Resolved Program stopped adding new entries at end of db; inserts them out of chrono order

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

No worries. I wish it were part of the default options, but that does not appear to be the case any longer. For more options when editing a post choose the Go Advanced button on the lower right of the page and there will be more formatting options. Alternately you can put your code in [CODE] [/CODE] tags.

For information on normalized tables I have found that this is a good place to start:

Here is the relevant code, including the formatting info. I realize that the mysql queries should be changed to mysqli. And that other aspects of this are probably embarrassing. I really have only a slight grasp of what I am doing much of the time.

No, I haven't tried that yet. It was all I could do today to open my cPanel and then open PHPMyAdmin, and then do some fiddling with the database -- really, all these kinds of things make me break out into a light sweat from anxiety.

Now I have to use ftp again for the first time in more than a year. More sweating! ;-)

As long as I'm going to try that, wherever 'mysql' appears, should I change that to 'mysqli' ??

I've made the change you suggested in the query, and it seems to have done the trick. (I didn't change anything else because I was concerned about 'unintended consequences.')

While making this change, I learned something else that should be a big help in the future -- it is possible to edit code while in cPanel. That will certainly be far more convenient in future than ftp'ing every little change.

This was great, James. Thank you for your patience and all your help. I'm truly grateful for both. :-)