not detecting true variable

[AN-net]

ok i have this variable set to true and i do not understand why it is not working:(


$grabfields= $DB_site->query("SHOW FIELDS FROM " . TABLE_PREFIX . "journal_settings");
while($field= $DB_site->fetch_array($grabfields))
{
if($field['Field'] == "version")
{
$versionexists= true;
}
else
{
$versionexists= false;
}
}
$DB_site->free_result($field);

if($versionexists)
{
echo "VERSION EXISTS!";
$checkversion= $DB_site->query_first("SELECT version FROM " . TABLE_PREFIX . "journal_settings LIMIT 1");
$prevversion= $checkversion['version'];
echo $prevversion;
}
else
{
echo "NO VERSION DETECTED!";
$upgrade= true;
$prevversion= "1.0.1";
}

it seems to keep thinking $versionexists is false even though it is true. also the field "version" does exist in the table.

[Marco van Herwaarden]

A few things:
- If the table contain more columns (i.e. A, version, C), the loop will be executed 3 times. $versionexist will be true after 'version' is read, and will be set to false again when C is read. Set $versionexist to false before entering the while, add a break after $versionexists = true, and remove the else part.

- Is 'Field' with an initial capital?

[AN-net]

yeah i figured it out, i had to remove the else statement.