die(dbGetErrorMsg()); } // Using dbQuery echo '<h2>Using dbQuery</h2>'; $sql = "SELECT TOP(10) Name FROM company"; $stmt = $dbBaseClass->dbQuery($sql); if ($stmt === false) { die(dbGetErrorMsg()); } while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) { echo $row['Name'] . ", " . "<br />"; } sqlsrv_free_stmt($stmt); // Using getAll echo '<h2>Using getAll</h2>'; $stmt = $dbBaseClass->getAll('Company'); if ($stmt === false) { die(dbGetErrorMsg()); } while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) { echo $row['Name'] . ", " . "<br />"; } sqlsrv_free_stmt($stmt); // Using getAllByFieldname echo '<h2>Using getAllByFieldname</h2>'; $stmt = $dbBaseClass->getAllByFieldName('Company', 'Name', 'Protea Security'); if ($stmt === false) { die(dbGetErrorMsg()); } while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) { echo $row['Name'] . ", " . "<br />";