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
