'ello all, am relative php newbie and would appreciate a little advice from some guru's out there.
I am organising a corporate christmas card that all members of staff at my firm can send. The basic idea is that they get a webform, which they fill in - and that populates a database. An e-mail is then sent to the recipient with a link, including the id of their message in the db, and when clicked, a page is opened which displays the corporate flash card along with their private message.
The problem I have is getting the unique id of the database entry into the e-mail that is sent.
The webform has fields for:
recipient name:
sender name:
recipient e-mail:
private message:
When a user submits the form, the info is stored in a MySql db with an auto_incrementing unique ID. So effectively I have to populate the db, then pull the unique id back before I can "send" the actual e-mail. Any ideas on how I can achieve this?
Many thanks