$row) { if ($tag == 'BREWCLUB') { $Chk=($brewer['BREWCLUB'] == 'Other') ? $brewer['OTHER'] : $brewer['BREWCLUB']; } else { $Chk=$brewer[$tag]; } if ($Chk != $brew_row[$row]) { $Notify=TRUE; $query='update brewer set '.$row.'="'.$Chk.'" where brewer='.$BrewerNo; if (!mysqli_query($db, $query)) { $e_brewer['UPDATE']=TRUE; } else { $query='insert into changelog values(null, null, "'.$Key.'", "brewer", "C", "'.$row.'", "'.$BrewerNo.'", "'.$brew_row[$row].'", "'.$Chk.'")'; mysqli_query($db, $query); if ($row=='email') { $query='select * from accts where brewer="'.$BrewerNo.'"'; $accts_res=mysqli_query($db, $query); $accts_row=mysqli_fetch_assoc($accts_res); $query='update accts set name="'.$Chk.'" where brewer="'.$BrewerNo.'"'; mysqli_query($db, $query); $query='insert into changelog values(null, null, "'.$Key.'", "accts", "C", "name", "'.$BrewerNo.'", "'.$accts_row['name'].'", "'.$Chk.'")'; mysqli_query($db, $query); } } } } } } if (array_search(TRUE, $e_brewer) !== FALSE) { if ($AdminAcct) { $Page='brewer.php?k='.$Key.($GoodAcct ? '&b='.$BrewerNo : '').'&s=1'; } else { $Page='brewer.php?'.($GoodAcct ? 'k='.$Key.'&' : '').'s=1'; } } else { $Page='brewer_ok.php?k='; if ($AdminAcct) { $Page.=$Key.'&a='.($Edit ? 'u' : 'c').'&n='.($Notify ? 'y' : 'n').'&b='.($Edit ? $BrewerNo : $Brewer); } else { $Page.=($Edit ? $Key.'&a=u' : $KeyVal.'&a=c' ).'&n='.($Notify ? 'y' : 'n'); } } ?>

Updating Brewer Information

$tagval) { if ($e_brewer[$tag]) { echo ''."\n"; } } } else { if (!$GoodAcct) { $query='insert into access values (null, "'.$brewer['EMAIL'].'", "'.$Brewer.'", "b", "C", "'.$_SERVER['REMOTE_ADDR'].'")'; mysqli_query($db, $query); } else { echo ''."\n"; } } ?>
'."\n"; echo '