Selecting records by field name

[Anon]

while i try to retrieve records by the field name, it aint functioning, but with the no is.Does interbase does'nt support the field names?

Here goes the simple code,

$db = 'Select * from TBL_CUSTOMERS';
$bsc = ibase_query($connection, $db);
while ($row = ibase_fetch_row($bsc)) {
$test2=$row[3];

INSTEAD IF I WRITE MY SELECT STATEMENT AS,

'select city from TBL_CUSTOMERS';

it does'nt fetch me the record and also when i try to do this in the following way

'Select * from TBL_CUSTOMERS';
$test2=$row['city']

is not working.

Any suggestions?

[Anon]

I would've said to use ibase_fetch_array(), like the other database functions, but for some wacky reason PHP doesn't have that.

Instead there's ibase_fetch_object(), and instead of $row['city'] use $row->city