2. PHPRunner General questions
  3. Insert a loops in after record added
This topic is locked

Insert a loops in after record added

 		1/26/2009 2:14:23 PM
PHPRunner General questions
P
 polaretto author

Hi,

i want to looping this line, but i'm not wery well in php coding..

i've insert it in After record added...
global $conn;

$strSQLInsert = "insert into magazzino_RiMe (IdAnagrafica, IDCarico, Colli_lotto1) values ('".db_addslashes($values["IdAnagrafica"])."','".db_addslashes($values["IdCarico"])."','".db_addslashes($values["Colli"])."' )";

db_exec($strSQLInsert,$conn);
and that works...
i want to do this..
from table in field Colli is 50 for example..
value from table in field infopallet is 20 for example
do.....
global $conn;

$strSQLInsert = "insert into magazzino_RiMe (IdAnagrafica, IDCarico, Colli_lotto1) values ('".db_addslashes($values["IdAnagrafica"])."','".db_addslashes($values["IdCarico"])."','".db_addslashes($values["Colli"])."' )";

db_exec($strSQLInsert,$conn);
..while..
I want to obtain in the table magazzino_RiMe 3 lines

one with 20 colli

second with 20 colli

and the third with 10 colli..
J
 		Jane 1/27/2009

Hi,
here is just a sample:

$i = $values["Colli"];

do {

$strSQLInsert = "insert into magazzino_RiMe (IdAnagrafica, IDCarico, Colli_lotto1) values ('".db_addslashes($values["IdAnagrafica"])."','".db_addslashes($values["IdCarico"])."','".db_addslashes($values["Colli"])."' )";

db_exec($strSQLInsert,$conn);

$i=$i-$values["infopallet"];

} while ($i > 0);