2. PHPRunner General questions
  3. Adding (capturing) data from table A to table B
This topic is locked

Adding (capturing) data from table A to table B

 		4/1/2009 3:29:20 AM
PHPRunner General questions
F
 futo author

HI,
in registration table i have fields A, B, C, D, E, F
i want to automatic add values from fields A, B, C, from registration table to another table in add page in fields A, B, C,
i can add only two field :
A with session variable $_SESSION["GroupID"]

B with session variable @$SESSION["" . $strTableName."_OwnerID"]
i ask how to add data to field C
Thanks
PHPRunner 5.1 1496
J
 		Jane 4/1/2009

Hi,
you can select value from registration table in the Add page: Before process event and save it in the session variable:

global $conn;

$str = "select C from UsersTable where UserName='".$_SESSION["UserID"]."'";

$rs = db_query($str,$conn);

$data = db_fetch_array($rs);

$_SESSION["C"] = $data["C"];
F
 		futo author 4/2/2009

Hi,

you can select value from registration table in the Add page: Before process event and save it in the session variable:


THANK YOU MARRY JANE - WORK 100%