sending email from database

[andynightingale]

I am building a membership form which will enter name, email etc into my database. I will generate a membership number for each entry starting at 000001 and auto-incrementing for each new entry.

How do I go about automatically sending the entrant an email with their name/ membership number. Can anyone point me to any articles/tutorials etc

thanks in advance for any help

[Roger_Ramjet]

As soon as you insert the new member into the table use mysql insert id to find out what the new id is. You can then use that in the email along with the other data you have used in the insert.

You use mail() to send the email.

[andynightingale]

Thanks Roger Ramjet

does that mean that I can only auto-increment the membership column ie not have a primary key that auto-increments as well?

[Roger_Ramjet]

Why would you want 2 autoincs?