Records from another table displayed on Edit page

Hi,
you can do it using EditOnLoad event on the Events tab for the Customers table.

You can see sample code for this event in the PHPRunner livedemo 3:

http://livedemo.asprunner.net/phprunner/li...p?editid1=10248
Here is a sample code:

global $strWhereClause;

global $conn;
$rs = db_query("select ID from Customers where ".$strWhereClause, $conn);

$data = db_fetch_numarray($rs);

$CustomerID = $data[0];

//

$rs1 = db_query("select Note, Date, Name from Notes where ID_Cust=".$CustomerID."",$conn);
$message.= "<TABLE cellSpacing=0 cellPadding=5 width=\"100%\"";

$message.= "align=center border=0><TBODY>";

$message.= "<tr><td colspan=3 class=downedit2>";

$message.= "<font color=black>Related Notes:</font>";
while ($data1 = db_fetch_array($rs1))

{

$Note = $data1["Note"];

$Date = $data1["Date"];

$Name = $data1["Name"];
$message.= "<tr><td>".$Note."</td>";

$message.= "<td >".$Date."</td>";

$message.= "<td >".$Name."</td></tr>";

}

$message.= "</TBODY></TABLE>";
echo $message;

You can download all live demos here:

http://www.xlinesoft.com/phprunner/livedemo4.htm

Hi,
just add order by clause to your SQL query:

...

$rs1 = db_query("select Note, Date, Name from Notes where ID_Cust=".$CustomerID."order by Date Desc",$conn);

...