Email upon new database entry?

[markspec87]

I have a page where users can submit thier own news / articles.

When they complete this form is there any code  ican use to email me that someone has added something (at the same time as it adds it to the database)

[Stevis2002]

Yes, i should think that you could do an 'if' statement which checks to see if the id, (which hopefully is auto incremented when a new record is inserted), has gone up one, and then in the statement put the mail function.

Something like that?

[roopurt18]

if(mysql_insert($sql) == 1){
  SendMail();
}

[Stevis2002]

An easier way might be to add the code into a function.
EG, the function which sends all the info to the db, should post an error if there is a problem, which makes your if - else statements.

So under the actual process for posting the info into the db, you could add the process for mailing a email to yourself, and if anythink fails, then it will give the user the standard db error