[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    Re: [PHP-DB] interbase (?) field contents does not show
From:       Meir kriheli <mksoft () netvision ! net ! il>
Date:       2001-04-29 21:48:17
[Download RAW message or body]

On Sunday 29 April 2001 19:00, GMansky wrote:
> I followed the documentation on interbase.  I have the following code:
>
> <?php
>     $rowcount = 0;    $dbh = ibase_connect ($host, $username, $password);
>     $stmt = 'SELECT * FROM contact';
>     $sth = ibase_query ($dbh, $stmt);
>     while ($row = ibase_fetch_object ($sth)) {
>         print $row->lastname . "\n";        $rowcount = $rowcount+1;
>     }
>     echo $rowcount;    ibase_close ($dbh);
> ?>
> $rowcount gave me the correct number of rows but referenceto any field name
> does not show anything.  I tried uppercaseand it still does not show
> anything.  Anything that I am missing?
> Thanks in advance,
> George

Hi George

Try using uppercase,  ibase_fetch_object will return fields as uppercase.

So:

print $row->LASTNAME;

You can see this info in the user contributed notes in the on line manual.

goto:

http://www.php.net/manual/en/function.ibase-fetch-object.php

-- 
Meir Kriheli

  There's someone in my head, but it's not me - Pink Floyd

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net

[prev in list] [next in list] [prev in thread] [next in thread]