[aston217]

I think this can be accomplished without a translate table in the DB.

...WHERE week = change_stage($current_stage_name, -1)...

function change_stage($current_stage_name, $n) {
    $lookup_stage_names = array(
        '0' => 'Pre_Staff_Draft',
        '1' => '...' //etc.
       );

    $key = array_search($current_stage_name, $lookup_stage_names);
    
    if ($key == false) { //default value
        $key = $current_stage; 
    }
    
       
    return $key;
}