Alan McDonald wrote:

> Lester
> Somehow this code
> $users_table = (isset($db_prefix) ? $db_prefix : '') . 'users';
>
> $sql = "SELECT * FROM $users_table WHERE user_id = '1'";
>
> // Check if we already have an Admin user.
> $result = $this->mDbConnection->Execute($sql);
> if ($result)
> {
> // If the record exists, we update it.
> $row = $result->FetchRow();
> $this->mAdminUsername = $row['user_name'];
> $this->mAdminPassword = $row['user_pass'];
> }
>
> results in an error: undefined index $row[user_name'];
>
> it works fine under MySQL
> any ideas?

firebird driver should be returning lower case field and table names. There is
a switch for it but I forget where.
I did try to convince people that upper case would be more logical but it fell
on deaf ears :(

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Firebird Foundation Inc. - http://www.firebirdsql.org/index.php