[SOLVED] What's wrong with this SQL query

[AdRock]

What is wrong with this SQL query????

 

What I am trying to do is check the database to make sure the new username they have chosen deosn't already exist (which works fine) but if they don't chnage their username, I need to ignore it.  At the moment it will check their username and return an error message.

 

What i need is to check the new username doesn't already exist and it's not the same as the username stored in the SESSION

 

I get this error message

PHP Parse error:  syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in d:\\Apache\\htdocs\\jack\\edit_profile.php on line 121

if( mysql_num_rows(mysql_query("SELECT username FROM users WHERE username = '$username'")) &&
	( !mysql_num_rows(mysql_query("SELECT username FROM users WHERE username = '$_SESSION['username']'")) {
	       $error['username'] = true;

[Fadion]

in this part of the if statement:

( !mysql_num_rows(mysql_query("SELECT username FROM users WHERE username = '$_SESSION['username']'"))

 

remove the first opening paranthese ( and add a closing one ).