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]