Need help with PHP and SQL integration

[jlatour88]

il try to explain as best i can. im new so please, any help would be awesome.
Im looking to have another part of my database update when one part is being updated. The way its setup now is that when i update a members user group it updates it on that particular DB Table then closes(which is working fine). but now id like to add another string to have it also update another table in the DB to a specific "Rank" aka (element?). for example when i update a members user group to a Recruiter i want it to update like usual as well as update the other table with the recruiter element of that table. So if im correct when i update a member it will change the element of both tables(other table will prob have a dif ID or name to it however). here is the code that i believe that i need to add too-

if (isset($_POST['updateclass'])) 
{
	$remuser = TRUE;
	$classcount = count($_POST['userclass'])-1;
	$currentClasses = array_flip($currentClasses);		// Back to having class number in data value
	for($a = 0; $a <= $classcount; $a++) 
	{
		$tmp = intval($_POST['userclass'][$a]);
		check_allowed($tmp);
		$currentClasses[] = $tmp;
	}
	$svar = implode(',', $currentClasses);
	$row['user_class'] = $svar;					// Get updated list back into user data
	$sql->db_Update("user", "user_class='$svar' WHERE user_id='$id' ");
	$message = UCSLAN_9;

[awbrowni30]

have you tried simply adding another $sql row below your initial update?

meaning:

$sql->db_Update("userA", "user_class='$svar' WHERE user_id='$id' ");
$sql->db_Update("userB", "user_class='$svar' WHERE user_id='$id' ");

[bradgrafelman]

If this is something that should always be done (e.g. there is a relationship being maintained with the second update), then another alternative would be to add a trigger to the DB schema so that the second update is performed automatically by the DB itself.