/** * select items with a select statment * * @depends testAddMultipleRecords */ function testSelectQuery() { // sleep for atleast one second between methods, it is only 'eventual consistency' sleep(1); $query = "select * from {$this->test_domain} where `letter_position` between '07' and '12' "; $result = SimpleDB::select($query); // assert 6 results came back $this->assertArrayCount($result, 6); // assert this known result was as expected, if so, assumme the rest are correct also $this->assertTrue(array_val($result, array('j', 'letter_position')) == '09'); }