Hi There
I'm fairly new to PHP and I'm currently working on a small website for testing purposes.
I am working on a customer form
I was previously using the auto_increment function in mysql to in order to generate a customer ID but I want a prefix on the beginning and you cant use VARCHAR with auto increment.
I want to be able to create a unique ID incrementing by 1 with a prefix e.g.
fill in the form and this generates a customer number of CN00001 then the next time you do it it will make CN00002,
how is this possible, if you can point me in the right direction I would be very grateful.
Many Thanks
Mooseh
