Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Universal Email › Submit UE trigger AFTER successful MYSQL insert

Submit UE trigger AFTER successful MYSQL insert

Thread began 3/19/2010 2:49 pm by web_assist_mail157665 | Last modified 3/23/2010 12:11 pm by web_assist_mail157665 | 2310 views | 5 replies

3/21/2010 9:27 amweb_assist_mail157665

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.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.