mmmh... i think its not coded the right way, first of all, you shouldn't put this:
$this->setArray(@mysql_fetch_array($this->getResultID())); in the Select method, you should do it in your FetchArray method, every time it gets called, and return the value directly or false if there are no more rows, an example: function FetchArray() { return @mysql_fetch_array($this->getResultID()); } or something like that "Jonathan Villa" <[EMAIL PROTECTED]> escribió en el mensaje news:[EMAIL PROTECTED] > I'm writing a DBI class with the following function > > function Select($sql) > { > $this->setResultID(@mysql_query($sql,$this->getDBConn())); > if ($this->getResultID() == false) > Error::fatalError(__FILE__.' ('.__LINE__.') : Unable to run query : > '.mysql_error().'('.mysql_errno().')'); > > $this->setNumRows(@mysql_num_rows($this->getResultID())); > $this->setArray(@mysql_fetch_array($this->getResultID())); > } > > > When I call this, I want to be able to run > > while($data = $objDBI->FetchArray) > { > echo $data['username']; > } > > but the results I get are > > jvillajvillajvillajvillajvillajvillajvillajvillajvillajvillajvillajvilla.... etc.... > > my $sql query is simple > > SELECT username FROM staff; > > and there are four rows in the db... > > > For some reason, I can't pass the value of mysql_fetch_array out of the > Select function. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php