Try this.
Code:
$db_select = @mysql_select_db($dbname,$db) or die('Mysql Database Failure');
$table_name = 'user';
$result = mysql_query("UPDATE '.$table_name.' SET usergroupid = '9' WHERE userid = '" . $username . "' LIMIT 1") or die(mysql_error());
Sorry for the delay. I had to look that up on php.net
I only usually do databases, not PHP.
Let me know if it works