> 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?
> Alan