$totalRows = mysql_result(mysql_query($countQuery), 0);
//*******************************************************************
//Lets set up the output
//*******************************************************************
$getHandler = new EBAGetHandler();
//First we define the columns we are sending in each record, and name each field.
//We will do this by using the EBAGetHandler_DefineField function. We will name each
//field of data after its column name in the database.
$getHandler->DefineField("ProductName");
$getHandler->DefineField("OrderDate");
$getHandler->DefineField("ShippedDate");
$getHandler->DefineForeignKey("CustomerID");
$getHandler->DefineForeignKeyValue($customerID);
// *******************************************************************
// Lets loop through our data and send it to the grid
// *******************************************************************
$nrows = mysql_num_rows($result);
for ($counter = 0; $counter < $nrows; $counter++) {
$row = mysql_fetch_array($result);
$record = new EBARecord($row["OrderID"]);
$record->add("OrderID", $row["OrderID"]);
$record->add("ProductName", $row["ProductName"]);
$record->add("OrderDate", $row["OrderDate"]);
$record->add("ShippedDate", $row["ShippedDate"]);
$getHandler->add($record);
}
$getHandler->SetTotalRowCount($totalRows);
$getHandler->CompleteGet();
?>
//field of data after its column name in the database.
$getHandler->DefineField("CustomerID");
$getHandler->DefineField("CustomerName");
$getHandler->DefineField("ContactName");
$getHandler->DefineField("ContactEmail");
$getHandler->DefineField("ContactTitle");
$getHandler->DefineField("PhoneNumber");
$getHandler->DefineField("Address");
$getHandler->DefineField("Country");
// *******************************************************************
// Lets loop through our data and send it to the grid
// *******************************************************************
$nrows = mysql_num_rows($result);
for ($counter = 0; $counter < $nrows; $counter++) {
$row = mysql_fetch_array($result);
$record = new EBARecord($row["CustomerID"]);
$record->add("CustomerID", $row["CustomerID"]);
$record->add("CustomerName", $row["CustomerName"]);
$record->add("ContactName", $row["ContactName"]);
$record->add("ContactEmail", $row["ContactEmail"]);
$record->add("ContactTitle", $row["ContactTitle"]);
$record->add("PhoneNumber", $row["PhoneNumber"]);
$record->add("Address", $row["Address"]);
$record->add("Country", $row["Country"]);
$getHandler->add($record);
}
$getHandler->SetTotalRowCount(100);
$getHandler->CompleteGet();
?>
