Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › How to insert multiple records with MySQLi server behaviours

View all replies to this thread

How to insert multiple records with MySQLi server behaviours

Thread began 3/27/2018 9:15 am by jon211112 | Last modified 3/28/2018 11:23 am by jon211112 | 819 views | 3 replies

3/27/2018 9:15 amjon211112

How to insert multiple records with MySQLi server behaviours

I have two tables - registrants and riders - and a form which contains fields for both tables. I want to process some of the fields and insert into the registrants table with a record. I then want to insert records into the riders table which has one field containing the ID of the newly inserted registrant record.

I've tried a number of ways to achieve this but none of them are working. I see you're close with a new version of the MySQLi Server Behaviours but it's still in beta so I'm reluctant to use it on a production site.

Can it be done with the existing version or should I go with the beta?

I don't want to use the previous Data Bridge as it's a new site so really needs to be running PHP7 and using MySQLi.

Cheers

Jon

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.