Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › How to insert the value of auto_increment to another field in "one" insert sql ???

View all replies to this thread

How to insert the value of auto_increment to another field in "one" insert sql ???

Thread began 10/27/2009 3:28 am by kakadong | Last modified 10/29/2009 10:24 am by kakadong | 4496 views | 5 replies

10/28/2009 9:58 amJason ByrnesWebAssist

Sorry, I missed that.

OK using that guys example, you need to create a new database connection to the MySQL information_schema database. Then create a recordset to look up the AUTO Increment ID for the table you will be inserting to:

SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA = '<database name.' AND TABLE_NAME = '<table name>'

In the insert record behavior, bind the xID column to the AUTO_INCREMENT column in the recordset.

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.