Create code base on year, month and number

[doxtor]

Hi all..
how can I make code, based on year, month and increment number?
the format is : Code + year+ month + number
for example, for document, it will have code :
DOC20080601
DOC20080602
DOC20080603
.
.
DOC20080699

I'm confuse because I don't know how to go to the last record in mysql. If use sqlserver, I can go to last record, get the number, and auto increment it. But, how can I make in php-mysql?

Thank you so much

[siMKin]

you could, for example, do an Order By Desc in combination with a Limit 0,1 to get the last record. or use MAX to get the highest value.

But you should ask yourself what happens if there are more then 99 documents in 1 month......

[doxtor]

can you explain clearly for
"do an Order By Desc in combination with a Limit 0,1 to get the last record..."
Still confuse with 'combination with a limit' :)
Yes, i know there is a limitation, that the document max is 99. That's just example.
thank you

[siMKin]

SELECT * FROM table ORDER BY id DESC LIMIT 0,1
or
SELECT MAX(id) FROM table

[doxtor]

thank you :)
I'll try that.