$query="SELECT fieldname, fieldlabel FROM vtiger_field WHERE tabid = (SELECT tabid FROM vtiger_tab WHERE name = 'Project') AND fieldname LIKE '%f_1994'";
$result=$adb->pquery($query,array());
echo"Fields ending with f_1994:\n";
while($row=$adb->fetch_array($result)){
$fieldname=$row['fieldname'];
$fieldlabel=$row['fieldlabel'];
echo"$fieldname - $fieldlabel\n";
}
// Также проверим структуру таблицы vtiger_project
echo"\nChecking vtiger_project table structure for f_1994:\n";
$query2="SHOW COLUMNS FROM vtiger_project LIKE '%f_1994'";