Order Number and Detail Product ID
Sorry, I need to clarify. It's all database driven. The OrderID field in the Orders table (created by eCart checkout) is an auto incremented number. It starts with 1. I want it to start with 0000001 and move forward to 0000099 (when it gets to 99), then 0000100 and so on. If I just add 0s on the page, it will always have the same amount of leading 0's so it won't do what I need. What I did is checked marked ZeroFill in the mySql db and gave it a length of 7 so it makes room for up to 1000000. I also changed it on the orderdetails page (generated by eCart), but although it's displays correctly on the dbs, it won't show with the leading 0s on the order receipt. Any ideas?
As far as the DetailProductId column, it's picking up the autoincremented ID field in my products db. I want to change it to pick it up from my 'MessageNumber' column, but I still can't find where to change this.