Aldark

I have a question. I have a form that I am storing submitted referrals in MySQL; at the same time I need to email the values to my client. I can do both individually, but cannot wrap my head around combining them into one action. This is my insert code and I want those values passed through to email. $sql = "INSERT INTO tbl_referral ( fname, lname, phone, phonetype, email $addl_insert_crit ) valueS ( '$fname', '$lname', '$phone', '$phonetype', '$email' $addl_insert_values )"; if ($sql_debug_mode==1) { echo "<BR>SQL: $sql<BR>"; } $result = mysql_query($sql,db()); Any thoughts or ideas would be great. Thanks

I prefer to hand-code most of what I'm doing so... I know what is going on with the code. The one real business website I did the client wanted me to use FrontPage because it was what they had... but they weren't even using the magical FP extensions on their server... so I said.... ummm no. Where I work now they only will allow FP200x on the computers for web development if you're maintaining a site, if you're doing web-based applications you can get dreamweaver or whatever... so I stick to HomeSite v1.2 (Sept 1996) because it doesn't edit the registry and can run off a floppy. It does enough of the inserting tags, but lets me control the content.