Its a lot easier to allow the database use its own auto_increment function for the ID then just create a field or fields with the other data.
However, if you want to still go this route, you can use the substring() function to select the first three chars and then concat the year on it.
__________________
I rarely give code examples.
No, I have never used IIS or Windows of any kind as a web server. Get a real OS!
Please don't PM me, I won't respond.
|