Problems changing cell data

[e39m5]

I am recieving a parse with the following code.
I have a feeling it is not setup right, so I am going to explain what I want it to do.
In the form that submits to this page, that variable perm is set to user, member, mmod, fmod, etc. I want it take that variable, and split it into 3 variables, $G, $P, and $S. If the password from the form is right, I want it to place those variables in the query and perform the query.

<?php
$Adminpw = "easychange";
$link = mysql_connect("localhost", "-----", "-----");
mysql_select_db("moparpo_pchat3", $link);
If ($_GET[PASSWORD] != $Adminpw) {
	echo "Wrong password!";
	exit();
}
if ($_GET[perm] == "user") {
	$G = 0
	$P = user
	$S = r
}
if ($_GET[perm] == "member") {
	$G = 0
	$P = game
	$S = g
}
if ($_GET[perm] == "mmod") {
	$G = 0
	$P = moderator
	$S = m
}
if ($_GET[perm] == "fmod") {
	$G = 0
	$P = fmod
	$S = f
}
if ($_GET[perm] == "msmod") {
	$G = 0
	$P = supermod
	$S = s
}
if ($_GET[perm] == "fsmod") {
	$G = 0
	$P = supermod
	$S = fs
}
if ($_GET[perm] == "admin") {
	$G = 0
	$P = admin
	$S = a
}
if ($_GET[perm] == "red") {
	$G = 0
	$P = admin
	$S = c
}
if ($_GET[perm] == "gag") {
	$G = 0
	$P = zgag
	$S = z
}
else {
mysql_query("UPDATE c_reg_users SET perms='$P', gender='$G' WHERE username='$_GET[U]'");
mysql_query("UPDATE c_users SET status='$S' WHERE username='$_GET[U]'");
}
?>

Thanks,
e39m5

[e39m5]

Well, I missed the obvious. On my if statements I am missing ;. I filled them in, now I am getting a new error.

Warning: mysql_connect(): Access denied for user: 'moparpo_pchat3@localhost' (Using password: YES) in /home2/moparpo/public_html/game/chat/gold.php3 on line 3

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home2/moparpo/public_html/game/chat/gold.php3 on line 4

Does this mean my user and pass are wrong?

e39m5

[Roger_Ramjet]

Yes.

[siwis]

Equally, although it isn;t causing a problem, use a switch() instead of all those if statements. Plus you have unbound strings which need enclosing in either single or double quotes.

switch ($_GET[perm])	{
	case "user":
		$G = 0;
		$P = "user";
		$S = "r";
		break;  

	case "member":
		$G = 0; 
		$P = "game";
		$S = "g";
		break;  

	case "mmod":
		$G = 0; 
		$P = "moderator";
		$S = "m";
		break;  

	case "fmod":
		$G = 0; 
		$P = "fmod";
		$S = "f";
		break;  

	case "msmod":
		$G = 0; 
		$P = "supermod";
		$S = "s";
		break; 
	case "fsmod":
		$G = 0; 
		$P = "supermod";
		$S = "fs";
		break; 
	case "admin":
		$G = 0; 
		$P = "admin";
		$S = "a";
		break; 
	case "red":
		$G = 0; 
		$P = "admin";
		$S = "c";
		break; 
	case "gag":
		$G = 0;
		$P = "zgag";
		$S = "z";
		break; 
};