add new column in current table

[alyousufi]

Hello all, 

i am doing something in my VA 

and i need to add new column \ filed in current table example 

table phpvms_pilot

i am already new filed for example total_daily_flights

i need to show the result of this filed in profile_main.tpl 

like <?php echo $userinfo->totalflights?>

when i change totalflight to = total_daily_flights , there is NO Change !

 

please i know i should add new line in some files can you teach me

like         $this->set('total_daily_flights', $totaldailyflights);

but where should be to add ? 

this is an example to be clear  

Edited May 3, 2018 by alyousufi