Submit UE trigger AFTER successful MYSQL insert

Am I missing the obvious

Is there a way to trigger UE, after a successful MYSQL insert. Current page is emailing even on fail? (yes I know I should cover all the options with validation) but it would be nice to know.

Only thing I can thing of is doing some comparison with mysql_insert_id() ???

tia

Yeah, the mysql_insert_id() is about the only thing I can thing of as well:

something like this should do the trick:
<?php if(mysql_insert_id() != "") { ?>
<Universal Email Code here>
<?php } ?>

Thanks - nice to know I was on the right lines.

Code snippet much appreciated.

Paul

The more I looked into this the more it looked like it could be a problem using
mysql_insert_id()

From what I can gather (please correct if wrong) mysql_insert_id() will return the insert id (of the previous successful - ie LAST BUT ONE) insert, even IF the LAST insert failed - if the connection is persistant.

Not too hot on this function so decided another route.

ie. to set the post trigger if my MYSQL Database Insert function didnt die, otherwise post trigger was constantly 'unset' every time the page ran - that seemed to do the trick.

unless I'm missing something, the only time an insert should fail is if there is a MySQL error.


On a Dreamweaver or DataAssist insert behavior the line that actaully connects to the database and performs the insert is:
$Result1 = mysql_query($insertSQL, $test) or die(mysql_error());


this basically says to run the insert query, and die() (or stop executing the script) if an error occurs. If the email behavior is after the insert behavior, it will not have a chance to execute once the insert fails.


is there another instance where your insert is failing besides an error?

Yeah... maybe just move the email code below the insert code... if the email code is first it will always happen.