Re: [PHP-DB] class method

[JJeffman]

I need a little more information to help you.
Is the $query variable a global one ? Or is it a property of the class ( var
$query; )  ?
Why are you assigning the "mysql_fetch_array" function to a variable if call
it is easier ?

You have misplaced the "if $result" statement, the right position, I think ,
is :

function getdata() {
    $this->sql = $query;
    $result = mysql_query($query);
    if( $result ) { // Check if $result is valid instead of NOT valid
       // $fetch = "mysql_fetch_array";
       while ($row = mysql_fetch_array($result)) {
             $this->field = $row['$this->field'];
        }
    }
    else  $this->error = mysql_error();
    return;
}

HTH

Jayme.

www.conex.com.br/jjeffman/antispam.html

-----Mensagem Original-----
De: bryan <[EMAIL PROTECTED]>
Para: db <[EMAIL PROTECTED]>
Enviada em: terça-feira, 20 de março de 2001 16:21
Assunto: [PHP-DB] class method


I am really new working with classes.  Some of the ideas I am getting, some
I am not.
I wrote this simple little class, with a connection method, and a method to
loop through the
data.  I am not even sure if my code is write (for the loop), but I am
having trouble
displaying the data.  My connection works fine, but my loop is jacked.
Could anyone
suggest or maybe correct a mistake (if you see any)?  Just looking to see if
I am
started in the right direction, or if I have this all bass ackwards.
I have no clue if this is even possible.  I am looking to create a while
loop for whatever
query I run, and make each row equal to whatever field I put in.  I have all
variables
defined within the scope of my class.

Thanks for your help.

Code :
********************************
function getdata() {

    $this->sql = $query;

    $result = mysql_query($query);

    $fetch = "mysql_fetch_array";

         while ($row = $fetch($result)) {

             $this->field = $row['$this->field'];

         }

                 if(!$result) {

                      $this->error = mysql_error();

                 return;

                }

}

******************************
End

thanks!!!

[ bryan fitch . programmer . [EMAIL PROTECTED] ]






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]