Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

Coding Forum


You are currently viewing our Coding Forum as a guest. Please register to participate.
Login



Reply
Extracting email fields to database
Old 09-06-2004, 01:10 PM Extracting email fields to database
Junior Talker

Posts: 2
Trades: 0
I have a tracking script which emails me whenever I have a new customer. The emails contain several fields which I would like to be entered into a database.
What's the simplest way to achieve this?

I have very little experience with databases and don't currently have one set up but my server has MySql so it would be logical to use that but my options are open. I'd appreciate any suggestions and links to relevant information or products.

Thanks
Takshaka is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 09-06-2004, 06:22 PM
webwoRRks's Avatar
Ultra Talker

Posts: 426
Location: I hope so
Trades: 0
You've got two choices;

1: Add a PHP script to parse incoming mail, syphon out the addresses them INSERT them into a mysql db, or...

2: If you have access to the tracking scripts, they can send the info directly to a script to insert the info into a MySQL db.
__________________
Theres 10 types of people; those who understand binary, and those who don't.
webmaster and webdeveloper resources,
Please login or register to view this content. Registration is FREE
webwoRRks is offline
Reply With Quote
View Public Profile Visit webwoRRks's homepage!
 
Old 09-06-2004, 08:12 PM
Junior Talker

Posts: 2
Trades: 0
Thanks for the input.

I'm not sure if it makes a difference but I don't just want the email addresses. The body of the emails contains form field data (eg Field1: data Field2: data etc.) which is what I want to get into a database (as well as the email address).

I do have access to the tracking scripts and guessed that it could be done that way but I don't know how to make the appropriate additions to the code (I'm not even sure which language the script is in!).
Takshaka is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Extracting email fields to database
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.18579 seconds with 12 queries