salman.pirani Posted November 24, 2012 Share Posted November 24, 2012 i hav a query i want that a a refrence number generate autometicly take the max num from database bas and +1 into it but when the year change like in 2013 it will again start from 1 could you help me plz in this regards .thanks Link to comment Share on other sites More sharing options...
salman.pirani Posted November 27, 2012 Author Share Posted November 27, 2012 sir can u please guide me Link to comment Share on other sites More sharing options...
justsomeguy Posted November 27, 2012 Share Posted November 27, 2012 I posted in your other thread, there's no reason to ask the same question multiple times. http://w3schools.invisionzone.com/index.php?showtopic=45696&view=findpost&p=255234 Link to comment Share on other sites More sharing options...
salman.pirani Posted November 30, 2012 Author Share Posted November 30, 2012 sorry sir, but sir how it will start from one again next year Link to comment Share on other sites More sharing options...
justsomeguy Posted November 30, 2012 Share Posted November 30, 2012 You can design it however you want. One way would be to store the max values for each year. If the current year isn't in the list then start a new counter. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now