Passing array from class to class produces more than one result...
| From: | Jonathan Villa | Date: | Wed, 10 Mar 2004 15:27:07 +0000 |
| Subject: | Passing array from class to class produces more than one result... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-180026@lists.php.net to get a copy of this message | ||
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.