So last night after dinner, I proceeded to rebuild my database. I dumped everything into Access, and created new tables from there. Why Access? Because I can *see* what is happening in Access, whereas in MySQL I have to take extra steps to see my results. The rebuilding wasn’t really as bad as I thought it would be, as I only needed relatively simple Access queries to manipulate my data.

From there, I uploaded the tables into MySQL, and proceeded to rebuild my php files to query the database.

With a minimum amount of bickering and quibbling, Michael and I were able to do that, although he kept trying to make one query much harder than it needed to be. Needless to say, by the time we finished up last night it was past my bedtime, which is why I didn’t have a post ready for this morning.

But the important thing is the new database is up and all public queries are working.

Now I just have to rebuild the administrative back end to allow me to add, edit, and delete books from the database. Hopefully now that the tables have better relationships, the rebuilding will be easier to do.

Hopefully.