Subject Re: [firebird-php] Problems conecting to Firebird 1.5 with PHP in RedHat 9
Author Lester Caine
Dariusz Zelichowski wrote:

> I had exactly the same problem with FB 1.03 and PHP 4 under
> Windows 2000 Server. ReferencING of fields by their index
> won't work but referring to them by field name works OK, so
> I just settled for that.
> So you may try changing your code to:
> while ($fila = ibase_fetch_row($resultado)) {
> echo $fila->FIELDNAME1.' '.$fila->FIELDNAME2.'<br />';

ibase_fetch_row() gives an array with column numbers as the field elements.
ibase_fetch_assoc() gives an array with column names as the field elements.

I had a problem with ADOdb working only with numbered fields, but going
direct is OK when I try it.

Try adding the field names to the query, using * is very sloppy, and you
may not get the same order of columns if the database is modified later!

Lester Caine
L.S.Caine Electronic Services