Subject | RE: [firebird-php] FireBird/ADODB |
---|---|
Author | Alan McDonald |
Post date | 2007-06-09T13:11:34Z |
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
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