villajay

Still learning php and mysql so hoefully this is an easy one. so the procedure goes as follows: user enters a new widget into the database, and the system automatically assigns an inventory number in the form ##-###. the first 2 numbers is the last 2 digits of the year, and the last 3 is a number that increments. auto-increment will not work since next year, it will have to start at 1. TIA!