not detecting true variable

[AN-net]

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

PHP Code:

    $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.