Yeah, the var $query is defined to the class.
I did mistype the result, thanks.
I was able to make this bad boy work with placing
$field = $row['row_name']; // whatever the row is called.
But, if that is the case, why would I need a class?
I am just trying to make it so that I can use the
loop for any query that needs it, and can show any row
when I need it.
I appreciate your help! Thanks a lot
bryan
----- Original Message -----
From: "JJeffman" <[EMAIL PROTECTED]>
To: "db" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 1:46 PM
Subject: Re: [PHP-DB] class method
> 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]
>
--
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]