Page 1 of 1

Need some Help!

Posted: Wed Jun 24, 2009 12:09 pm
by ralmaraz
Hello i need some help with a code:

In my work to identify each file using a reference number as this:

www01001020901

the number is formed like this the first three letters correpond to the initials of N ompany following two numbers 01 correspond to an office, then the following three consecutive number.
the next two numbers correspond to the month. the next two correspond to the year in which we come and then the last two numbers correspond to the office or location where you work in this case.

we have 6 locations.

And they can not afford to duplicate the reference number and this information should be sent to a database in mysql, I hope I can help. via email to almaraz.rodolfo@gmail.com

Re: Need some Help!

Posted: Wed Jun 24, 2009 12:18 pm
by iBroughtCookies
How is php supposed to know what the company name is, and what office someone is in?

You need to give us some more information about this.
What is it for? Does it just need to be displayed at the top of the page, or is it being used to monitor people, I.E. who logs in where?
Would the latter then mean that this person has already logged in, and the info, I.E. what office they're in would be entered when they register for an account?

Re: Need some Help!

Posted: Mon Jun 29, 2009 10:01 am
by ralmaraz
Well thank you for your reply,

This a reference number of a file in my office

SIN01002060901

This is the way that i create the reference number

SIN= Initials of a company
firts two numbers= office number there are six
next three numbers= consecutive number of the month this goes from 001
until the mont finish and then restart for the next month 001 002,
102...next month back to 001 ok?
Next two numbers= correspond to the month
Next two numbers= correspond for the year
last two number = correspond to the office (same six as the first two
numbers)

This number has to be created when the user(me) fill the form to register a
event and when a submit the data has to create this unique reference number
and we can not duplicate this numbers.

how i can i do that?

regards