unexpected T_ELSE.. what does that mean?

[jwk811]

something is wrond with the else but i dont know what im doing wrong

[code] echo "<strong><font color='red'>Your account could not be activated, no user found by that id or password!</font></strong>";
}
else
{
echo "<strong>Your account has been activated!</strong> You may login below!<br />";

    include ( './login.php' );
}
}
else
{
echo "<strong>You have already activated your account!</strong> You may login below!<br />";

    include ( './login.php' );
}[/code]

it says in the error

Parse error: parse error, unexpected T_ELSE in /home/content/j/w/k/jwk811/html/membership/activate.php on line 28

not sure what that means..

[EngineeringGuy]

Do you have an if statement?  Also, depending on the code above it, you may have too many }

[jwk811]

heres the entire script.. its to activate a user
[code]<?

/* Account activation script */

// Get database connection

include ( './db.php' );

// Create variables from URL.

// first check if it's already been activated

$sql = mysql_query ( "SELECT COUNT(*) AS total FROM users WHERE userid = '" . mysql_real_escape_string ( $_REQUEST['id'] ) . "' AND password = '" . mysql_real_escape_string ( $_REQUEST['code'] ) . "' AND activated = 1" ) or die ( 'Query Error: ' . mysql_error );

$found = mysql_fetch_assoc ( $sql );

if ( $found['total'] == 0 )
{
$sql = mysql_query ( "UPDATE users SET activated = 1 WHERE userid = '" . mysql_real_escape_string ( $_REQUEST['id'] ) . "' AND password = '" . mysql_real_escape_string ( $_REQUEST['code'] ) . "'" ) or die ( 'Query Error: ' . mysql_error );

if ( mysql_affected_rows ( $sql ) == 0 )
        {
        die(mysql_error());
        }
{
echo "<strong><font color='red'>Your account could not be activated, no user found by that id or password!</font></strong>";
}
else
{
echo "<strong>Your account has been activated!</strong> You may login below!<br />";

    include ( './login.php' );
}
}
else
{
echo "<strong>You have already activated your account!</strong> You may login below!<br />";

    include ( './login.php' );
}

?>[/code]
i didnt write it so i wouldnt know much on why its wrong cuz im not all that great with this just yet... please let me know if you find any problems with this.. if its the if thing.. how would i set it up? thanks again

[jwk811]

do you know what the problem is anyone? please help me

[Design]

i'm getting this error lately too on one of my scripts, i'm pretty sure that it means you have more than 1 else { } statement in an if statement

[sasa]

try[code]<?
/* Account activation script */
// Get database connection
include ( './db.php' );
// Create variables from URL.
// first check if it's already been activated
$sql = mysql_query ( "SELECT COUNT(*) AS total FROM users WHERE userid = '" . mysql_real_escape_string ( $_REQUEST['id'] ) . "' AND password = '" . mysql_real_escape_string ( $_REQUEST['code'] ) . "' AND activated = 1" ) or die ( 'Query Error: ' . mysql_error );
$found = mysql_fetch_assoc ( $sql );
if ( $found['total'] == 0 )
{
$sql = mysql_query ( "UPDATE users SET activated = 1 WHERE userid = '" . mysql_real_escape_string ( $_REQUEST['id'] ) . "' AND password = '" . mysql_real_escape_string ( $_REQUEST['code'] ) . "'" ) or die ( 'Query Error: ' . mysql_error );

if ( mysql_affected_rows ( $sql ) == 0 )
        {
        echo "<strong><font color='red'>Your account could not be activated, no user found by that id or password!</font></strong>";
        die(mysql_error());
        }
else
{
echo "<strong>Your account has been activated!</strong> You may login below!<br />";

    include ( './login.php' );
}
}
else
{
echo "<strong>You have already activated your account!</strong> You may login below!<br />";

    include ( './login.php' );
}
?>[/code]

[HuggieBear]

The error is occuring because on line 25 you have an open curly bracket [color=green][b]{[/b][/color] but it's not preceeded by an [color=green][b]else[/b][/color].

The code that sasa's provided should clear it up.

Regards
Huggie