[Resolved] parse error, unexpected T_STRING

Barb54

Hi, it's me again, lol.
Well, at least I'm making progress, lol. Ok, my form is up now with connecting to 2 different table for dropdown lists of country and state. Thanks those of you that helped with that.

Now I am working on the "insert" file for inserting all my form data into the database. I'm getting an error on Line 49. Here's the errror msg and what I have done so far:

1 - include statement for db connect file
2 - assigned all post variables from the form
ie $nick=$POST['nick'];$email=$POST['email'];
3 - checked for blank fields to give error msg on certain fields
4 - checked 'yes/no' answers to give error msg

Parse error: parse error, unexpected T_STRING in C:location\apps.php on line 49

Everything "seems" to work up to this point. I have fixed all other syntax errors so far. But I can't really "see" this one for some reason.

//5 - check to see if email already exists in database

$sql="SELECT * FROM players;
$result=mysql_query($sql,$dblink);
	if ($email == 'email') {

//line with error - LINE 49
	echo "You already have an account with us.  You can only have 1 account.  Application is rejected.";
}
	else {

$sql="insert into players
	etc etc;

$result = mysql_query($sql);

}

?>

Any suggestions? What does that error mean? I don't know what to look for.

Thanks in advance,
Barb

lazzerous

$sql="SELECT * FROM players;

should be

$sql="SELECT * FROM players";

Barb54

Thank you so much. I couldn't see that for anything, lol. I did a search on the forum for that error message but still couldn't see the mistake. Now I know what to look for.

I will see if I can get this one marked as resolved.

Thanks again!
Barb