Jump to content

Reset count to zero


realjumper

Recommended Posts

Hi,

 

On our Intranet, staff can fill in a form requesting permission to purchase items for their department. The online form is numbered like this:

 

NZ - 06 - 183

 

....where 06 represents the current financial year, and 186 represents the form number....which is incremented by 1 by selecting the last entry in the db and adding '1' to it. What they want now is for the counter to reset to 001 for the first form filled in at the beginning of the new financial year. By using the date() function and an 'if / else' statement I can determine the start of the new finacial year, but how will I reset the counter to 000....so that the first form filled in on April 1st will have the number 'NZ - 07 - 001'?

Link to comment
https://forums.phpfreaks.com/topic/43409-reset-count-to-zero/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.