Welcome Guest, Not a member yet? Register   Sign In
combining two rows wit the Query Builder
#4

(07-07-2021, 04:08 AM)richb201 Wrote: The problem is that they don't exist in any table prior to me inserting them. I am going from a table that has this form

Then why do you insert 2 rows if you want all the data in a single row? The best way to do this would be to collect all the data in a single array and insert only one row. Or another less efficient way would be to check if a row already exists for this "taxyear" and do an update instead of an insert.
CodeIgniter 4 tutorials (EN/FR) - https://includebeer.com
/*** NO support in private message - Use the forum! ***/
Reply


Messages In This Thread
RE: combining two rows wit the Query Builder - by includebeer - 07-08-2021, 06:56 AM



Theme © iAndrew 2016 - Forum software by © MyBB