dealbyethan,

Unfortunately, this modification is too broad, and there are too many settings/etc. that makes it difficult to troubleshoot what might be wrong for you. I've tried to guide you towards fixing/adding what you requested, but I don't think I'm really able to help you much more with such broad problems.

First thing you need to do is troubleshoot your SQL errors that you are getting. You have to remove all the errors - that's step one.

Then, you need to play around with the code - and the things I suggested. Use PHP to help you (echo out variables, etc.). You've got to get your hands dirty to figure out the problem sometimes.

Once you've ridded of the errors - and you've played around with the code for a while, and then you've got more specific questions, I might be able to help you more. Without actually having your store to work with - and your code, I can't do a whole lot of help.

All of my modifications of this have taken me a lot of time and testing. Good luck bro!