Jump to content

Archived

This topic is now archived and is closed to further replies.

jwk811

Please Help Me.. Whats wrong with this?

Recommended Posts

Heres my account activation form. Keep getting the same problem which looks like this:
[tt]Parse error: parse error, unexpected T_ELSE in /home/content/j/w/k/jwk811/html/membership/activate.php on line 28
[/tt]
Have no idea whats wrong with this.. I bolded line 28 where it says else.. what's wrong with it? Please help me I'm having so much problem with this, it's driving me crazy!
[code]<?php

/* 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>";
}
[b]else[/b]
{
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]
Thank you so very much for any help!

Share this post


Link to post
Share on other sites
[code]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(strlen(mysql_error()) > 0)
{
die(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>";
}
else
{
echo "<strong>Your account has been activated!</strong> You may login below!<br />";

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

I think what you [i]meant[/i] is to do something like this :)

Orio.

Share this post


Link to post
Share on other sites
[code]<?php

/* 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(strlen(mysql_error()) > 0)
{
die(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' );
}
}
?>[/code]
if i dont add in that die(mysql_error()); after if ( mysql_affected_rows ( $sql ) == 0 ) i get some other error that has to do with if ( mysql_affected_rows ( $sql ) == 0 ).. when i add in the die(mysql_error()); that same T_ELSE error is coming up exept now with your new code its the else closest to the end that has the problem.. thanks for trying but would you happen to know whats wrong still?

Share this post


Link to post
Share on other sites
What error are you getting for the mysql_affected_rows? You cant do what you wrote because the if cant have two blocks of curly braces.

Orio.

Share this post


Link to post
Share on other sites
[tt]Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource in /home/content/j/w/k/jwk811/html/membership/activate.php on line 25[/tt]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.