* - Create a variable to hold the results and call retrieve(). * 2.) You can retrieve only results from one row. * - Create a variable to hold results, call retrieve() * and pass the row number (indexed 0-i). * 3.) You can omit certain fields from the result. * - Create an array of the columns you would like to omit. * then call the ignore method with the array of omitted columns. * * To display results, create a variable to hold the result from the * retrieve method. Next create a variable to hold the array of rows * that is returned from the get rows method. Create a nested foreach * loop, the inner loop will give access to the column name and its value. * */ $db->setTable("test1"); $result = $db->retrieve(); /* Obtain all results from a table. * Print all fields with thier value. */ $tableRows = $result->getRow(); // Gets all rows from table foreach ($tableRows as $row) { foreach ($row as $field => $value) { echo $field . " => " . $value . "</br>"; } } /* Obtain results from certain row in table. * Print all fields with thier value. */ $tableRow = $result->getRow(0); // Get the first row from table