Form Mail script with auto sequential numbering

norm999999 · #1 (**permalink**) 12-04-2003, 07:59 PM

hello... I'm looking for an email form script that will add an identification number to each msg sent automatically and increase the number sequentially when the next msg is sent. Any suggestions?

mysticlighthouse · #2 (**permalink**) 12-04-2003, 08:17 PM

Could you provide some more information?

Will you be using any server side languages (asp, php, coldfusion)? a database (mysql, oracle, ingris)?

Describe thoroughly the process that you are wanting. Thanks.

norm999999 · #3 (**permalink**) 12-05-2003, 01:53 AM

Sorry for being vague. A restaurant client wants a form on their site for people to request gift certificates online. The form would sendmail the request to the restaurant admin and the requester. The form will have some standard info fields (name, phone, $$ amount, etc.) They want a unique identifier automatically generated on each request that would be incuded on the email msssages.

The first request would be transaction #0001. The next person to make a request would be transaction #0002. And so on...

The form program will be serverside, either PHP or pearl. I can set up any of several form processing programs for sending the emails, but have not found one that will add a transaction number that will generate and sequence automatically.

Hope this helps explain. Any help would be greatly appreciated!

Norm

mysticlighthouse · #4 (**permalink**) 12-05-2003, 04:56 PM

Simplest way would be to open a text file, read the number from the file, increment the number and then rewrite the file with the new number. You should have no problem doing it with Perl.

Then you could include it in the message body or whatever by a server side include.

sijpie · #5 (**permalink**) 12-08-2003, 08:46 AM

Alternatively, you could log each transaction in a database (instantly creating a record of buyers and their email addresses!!) and pull up the next number from the database prior to writing the form.

mysticlighthouse · #6 (**permalink**) 12-08-2003, 08:20 PM

sijpie,

that's why I originally asked him first about server side scripting languages and then databases... from his answer it doesn't look like a database has been considered, so an alternative needed to be given.

AlexBel · #7 (**permalink**) 12-15-2003, 09:25 PM

If your site lending on the server with Perl and PHP it easy to make script.
What does your server have?