// Retrieve all the data from the "example" table $myQuery = "SELECT * FROM tblorders WHERE CustomerID=" . $customerID . " ORDER BY " . $sortColumn . " " . $sortDirection . " LIMIT " . $ordinalStart . "," . $pageSize . ";"; $result = mysql_query($myQuery) or die(mysql_error()); $countQuery = "SELECT COUNT(*) AS totalRowCount FROM tblorders where CustomerID=" . $customerID; $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);