Thanks, I wondered why the values were empty. But I don't understand php enough to add what I want to happen and hope you can provide the code.
My client wants the customerID to increment by 1 with each new customer. (I assume this will go into the Visitors database, we started with the arbitrary #135).
The invoice number goes into Orders and OrderDetails (I assume), my client wants this year's records in increments of 11000, incremented by 1 for each new invoice. I've manually added the first entry in mysql, with an invoice number of 11001 and a customerID of 135 (and my client's name and address data).
In my rudimentary understanding of mysql & php, I'm guessing that there has to be some check to see if this customer exists already and pulls up their customerID, if it doesn't find the individual in the visitors database there is a way to find the maximum ID number that exists and increment this by +1 and assign this to the new client. Is this how it works, and can you help with this code?
Invoice# seems a bit more straight forward, by obtaining the maximum invoiceID that exists and incrementing it by +1 and assigning that number to the new invoice.
Thanks for your help in advance.