Please see if you can point out the parse errors

[abstrakt]

I am getting parse errors on the following lines, can someone please shed some light on why ?

Thank you in advance.

$sql_email_check = mysql_query("SELECT email_address FROM users WHERE email_address='$email_address'"); 

$sql_username_check = mysql_query("SELECT username FROM users WHERE username='$username'");

  $salt = "abchefghjkmnpqrstuvwxyz0123456789";

(this last one "salt" is the seed for a random pass gen.)

[CorySchop]

humm just a thought try setting your query equal to something firt.. then pass that into the query function

Like so

$query = "SELECT email_address FROM users WHERE email_address='$email_address'";

then

$query_result = mysql_query($query);

try echoing out the query.. try running your result from your echo into an sql form.. I use an admin tool for this.

Hope this helps

[sweatje]

Do you perhaps have an unterminated string prior to these lines of code?

[abstrakt]

Do you perhaps have an unterminated string prior to these lines of code?

Thank you for the reply, would it alert me if I did ? The first error I get is a parse error for the first line I quoted above.

[sweatje]

Thank you for the reply, would it alert me if I did ? The first error I get is a parse error for the first line I quoted above.

consider the code:

$foo = "something\";
$sql_email_check = mysql_query("SELECT email_address FROM users WHERE email_address='$email_address'"); 

which you can see from the syntax highlighting will clearly be a PHP syntax error on your line of code becuase of the unterminated string constant.

[CeleronXL]

Post code from before those lines.

[abstrakt]

include 'incl/db.php'; 
// Define post fields into simple variables 
$first_name = $_POST['first_name']; 
$last_name = $_POST['last_name']; 
$email_address = $_POST['email_address']; 
$username = $_POST['username']; 
$location = $_POST['location']; 
$age = $_POST['age']; 
$homepage = $_POST['homepage']; 
$icq = $_POST['icq']; 
$aim = $_POST['aim']; 
$yahoo = $_POST['yahoo']; 
$msn = $_POST['msn']; 
$fav_trick = $_POST['fav_trick']; 
$fav_pro = $_POST['fav_pro']; 
$skate_setup = $_POST['skate_setup']; 

/* Let's strip some slashes in case the user entered 
any escaped characters. */ 
$first_name = stripslashes($first_name); 
$last_name = stripslashes($last_name); 
$email_address = stripslashes($email_address); 
$username = stripslashes($username); 
$location = stripslashes($location);
$age = stripslashes($age);
$homepage = stripslashes($homepage);
$icq = stripslashes($icq);
$aim = stripslashes($aim);
$yahoo = stripslashes($yahoo);
$msn = stripslashes($msn);
$fav_trick = stripslashes($fav_trick);
$fav_pro = stripslashes($fav_pro);
$skate_setup = stripslashes($skate_setup);


/* Do some error checking on the form posted fields */ 
if((!$first_name) || (!$last_name) || (!$email_address) || (!$username) || (!$location) || (!$age)){ 
echo 'You did not submit the following required information! <br />'; 
if(!$first_name){ 
echo "First Name is a required field. Please enter it below.<br />"; 
} 
if(!$last_name){ 
echo "Last Name is a required field. Please enter it below.<br />"; 
} 
if(!$email_address){ 
echo "Email Address is a required field. Please enter it below.<br />"; 
} 
if(!$username){ 
echo "Desired Username is a required field. Please enter it below.<br />";
}
if(!$location){ 
echo "Location is a required field. Please enter it below.<br />"; 
}
if(!$age){ 
echo "Age is a required field. Please enter it below.<br />"; 
}
"; 
} 
include 'join_form.html'; // Show the form again! 
/* End the error checking and if everything is ok, we'll move on to 
creating the user account */ 
exit(); // if the error checking has failed, we'll exit the script! 
} 

[abstrakt]

There's also the db.php file, would it matter, assuming it would, here it is:

$db = mysql_connect("localhost","dbuser","dbpass") or die("Could not connect to the database !");
mysql_select_db("database_name") or die("The database does not exist !");

[abstrakt]

:'(

[sweatje]

can you change your [ code ] tags to [ php ] tags in post #7 to enable syntax highlighting?

[abstrakt]

can you change your [ code ] tags to [ php ] tags in post #7 to enable syntax highlighting?

Done, thank you very much, I appreciate your time in helping me out !

[sweatje]

I do not see the lines you posted in #1 in #7. Are they the same script?

[CeleronXL]

Find:

if(!$age){
echo "Age is a required field. Please enter it below.<br />";
}
";
} 

Replace with:

if(!$age){
echo "Age is a required field. Please enter it below.<br />";
}
} 

[abstrakt]

Still not working.

Yes, it is the same script, the lines in post #1 come after the lines in the above script. I am still getting the parse error on the same lines.

This is wacky, I bet it's something simple too. Grr.

[sweatje]

CeleronXL found your unterminated string declaration. There is still something wrong after that?

[abstrakt]

CeleronXL found your unterminated string declaration. There is still something wrong after that?

Yea, still getting parse errors for the same exact lines. WOuld MySQL 3.23 be the problem ?

This stinks. :'(

[abstrakt]

Dangit.

[abstrakt]

bump

[Viper78]

try this

include 'incl/db.php'; 
// Define post fields into simple variables 
$first_name = $_POST['first_name']; 
$last_name = $_POST['last_name']; 
$email_address = $_POST['email_address']; 
$username = $_POST['username']; 
$location = $_POST['location']; 
$age = $_POST['age']; 
$homepage = $_POST['homepage']; 
$icq = $_POST['icq']; 
$aim = $_POST['aim']; 
$yahoo = $_POST['yahoo']; 
$msn = $_POST['msn']; 
$fav_trick = $_POST['fav_trick']; 
$fav_pro = $_POST['fav_pro']; 
$skate_setup = $_POST['skate_setup']; 

/* Let's strip some slashes in case the user entered 
any escaped characters. */ 
$first_name = stripslashes($first_name); 
$last_name = stripslashes($last_name); 
$email_address = stripslashes($email_address); 
$username = stripslashes($username); 
$location = stripslashes($location);
$age = stripslashes($age);
$homepage = stripslashes($homepage);
$icq = stripslashes($icq);
$aim = stripslashes($aim);
$yahoo = stripslashes($yahoo);
$msn = stripslashes($msn);
$fav_trick = stripslashes($fav_trick);
$fav_pro = stripslashes($fav_pro);
$skate_setup = stripslashes($skate_setup);


/* Do some error checking on the form posted fields */ 
if((!$first_name) || (!$last_name) || (!$email_address) || (!$username) || (!$location) || (!$age)){ 
echo 'You did not submit the following required information! <br />'; 
if(!$first_name){ 
echo "First Name is a required field. Please enter it below.<br />"; 
} 
if(!$last_name){ 
echo "Last Name is a required field. Please enter it below.<br />"; 
} 
if(!$email_address){ 
echo "Email Address is a required field. Please enter it below.<br />"; 
} 
if(!$username){ 
echo "Desired Username is a required field. Please enter it below.<br />";
}
if(!$location){ 
echo "Location is a required field. Please enter it below.<br />"; 
}
if(!$age){ 
echo "Age is a required field. Please enter it below.<br />"; 
}
include 'join_form.html'; // Show the form again! 
exit();
} 

you had more } than {

Hope this helps

Viper

[abstrakt]

YOU ARE THE MAN ! Thank you !

[Viper78]

your welcome glad to help.