2. PHPRunner General questions
  3. master table info displayed on ADD page
This topic is locked

master table info displayed on ADD page

 		8/22/2005 10:50:14
PHPRunner General questions
C
 crono999 author

Regarding previous postings of mine, I have found out how to direct a user directly from the LIST page of a master table to it's child's ADD page when they click the child's table name. However, I'm wondering if I can have the master table data displayed across the top of the ADD page like it is on the child's LIST page. Thank you for any help possible...
Sergey Kornilov admin 8/23/2005

Hi,
here is what you should do to display master table info on Add page.

  1. Copy DisplayMasterTableInfo, GetLinkPrefixMaster and AddLinkPrefixMaster functions from the end of ..._list.php to ..._add.php
  2. Insert the following lines

$masterkey=$_SESSION[$strTableName."_masterkey"];

$detailkeyfield=RemoveFieldWrappers("`ORDERID`");

just before

$defvalues=array();

line in ...add.php. "$detailkeyfield=.." line shoul be copied from ..._list.php
3. Find the snippet looking like this in ..._list.php and insert it in ...add.php after two lines inserted before. Don't forget to take care of <?php ?> elements.

<?php if($masterkey) {?>

<table><tr><td width=20>&nbsp;</td><td><p>Master table: [orders]</p></td></tr></table>

<table rows='1' cols='1' align='center' width='95%' border='0'>

<tr><td align="right">

<TABLE WIDTH=100% CELLPADDING=0 CELLSPACING=0 BORDER=0>

<TR><TD BGCOLOR=black align=center>

 <table border=0 width=100% CELLPADDING=3 CELLSPACING=1>

 
<?php

$strMasterSQL = AddWhere("select `ID`,   `TIME`,   `Customer`   From `orders` ",AddFieldWrappers("`ID`")."=".make_db_value($detailkeyfield,$masterkey));

LogInfo($strMasterSQL);

$rsMaster=db_query($strMasterSQL,$conn);

DisplayMasterTableInfo($rsMaster);

?>

</table>

</td></tr></table>

</td></tr></table>
<?php } ?>
C
 		crono999 author 8/26/2005

worked beautifully, thank you.

did have some issues with the <?php ?> elements just as you warned about though.