Select and multi insert

Scriptcase 9
#1

Hey guys, long time :slightly_smiling_face:
Isn’t Scriptcase just great :slight_smile:

I Am stuck on a little script, selecting fields from one table and inserting multiple in another, this is what I got so far and it’s throwing me an error…
For sure a simple mistake, but this one always eludes me :frowning:

$assoc = ‘’;
sc_select(rs, “SELECT associate_type_id, name, address FROM client_associates WHERE company_id = ‘[company_id]’”);
while(!$rs->EOF)
{
$assoc[] = $rs->fields[0];
$rs->MoveNext();
}
$rs->Close();

if (isset({rs[0][0]})) // Row found
{
foreach($assoc as $key => $value)
{
$sql = “INSERT INTO trans_associates(usr_login, client_id, trans_id, company_id, associate_type_id, shareholder, shareholder_address) VALUES (’”. [usr_login] ."’, ‘". [client_id] ."’,’". [trans_id] ."’,’". [company_id] ."’,’". $assoc[0] ."’,’". $assoc[1] ."’,’". $assoc[2] ."’)";
sc_exec_sql( $sql );
}
}

#2

Your code is wrong.
Anyway, you could do everything in one loop:
sc_select(rs, “SELECT associate_type_id, name, address FROM client_associates WHERE company_id = ‘[company_id]’”);
while(!$rs->EOF)
{
$sql = “INSERT INTO trans_associates(usr_login, client_id, trans_id, company_id, associate_type_id, shareholder, shareholder_address) VALUES (’”. [usr_login] ."’, ‘". [client_id] ."’,’". [trans_id] ."’,’". [company_id] ."’,’". $rs->fields[0] ."’,’". $rs->fields[1] ."’,’". $rs->fields[2] ."’)";
sc_exec_sql( $sql );
$rs->MoveNext();
}
$rs->Close();

#3

my coding sux :slight_smile: but thanks to SC I can be a star :slight_smile:
Thanks Roby worked a treat, much easier to understand now also!