[SOLVED] unexpected T_VARIABLE problem

[RyanSF07]

Hi Guys,

 

I'm getting this error:

Parse error: syntax error, unexpected T_VARIABLE on line 26

 

with this bit of code (line 26 begins with: $check2)

 

	$usercheck = $_POST[user_name];
$check = mysql_query("SELECT * FROM registered_users WHERE user_name = $usercheck") 
$check2 = mysql_num_rows($check);

//if the name exists, error
if ($check2 = 0) {
	$c = TRUE;
} else {
	$c = FALSE;
	$content .= "<p>'Sorry, that username is already in use.'</p>\n";
}

 

Later in the script I have a: if $a AND $b AND $c AND $d then do the INSERT

 

Can you help me trouble shoot this? Where is the syntax error?

 

Thank you!

Ryan

[sasa]

ad ; on the end of line 25

[RyanSF07]

Thanks. I added it, and now get this error:

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /page/ on line 26

 

 

[metrostars]

change the line to:

 

$check = mysql_query("SELECT * FROM registered_users WHERE user_name = $usercheck")or die(mysql_error());

 

and make sure that you put the error bit on the end ofthe connection as well.

[RyanSF07]

got it. now I get this error:

 

Unknown column 'test' in 'where clause'

 

the column name and $post are getting confused.

 

What should I change to fix this?

 

Thanks very much for your help!

 

 

[metrostars]

$check = mysql_query("SELECT * FROM registered_users WHERE user_name = '$usercheck'")or die(mysql_error());

[RyanSF07]

Thanks for your help Metrostars.

 

The single quotes did the trick.

 

Cheers,

Ryan