Missing syntax, can not find in code

[komquat]

Sorry to post all this code, but I am getting an error:

Parse error: syntax error, unexpected $end in /home/andybour/public_html/admin/master_user_info.php on line 408

Meaning missing syntax.  I have looked for 24 hours and can not find.  Help is appreciated.


[code=php:0]
<?
//Session Starting
session_start();

if ($_SESSION[level] != "full_admin") {
header("location:http://www.andybourdeau.com/");
exit;
}

include("include/connection.php");

//Update the information if needed
if ($run_master_update == "yes") {
$sql_update = "UPDATE users SET
last_name = '$_POST[master_l_name]',
password = '$_POST[master_pass]',
permission = '$_POST[master_per]',
email = '$_POST[master_email]',
fantasy_nascar = '$_POST[master_1st]',
fantasy_nascar_2 = '$_POST[master_2nd]',
fantasy_football = '$_POST[master_FF]'
WHERE user_id = '$_POST[master_user_id]'
";

$result = mysql_query($sql_update, $connection) or die ("Could not Execute query. Reason: ".mysql_error());

//Delete from nascar 1st and Nascar 2nd if user was a member of the Nascar
if (($_POST[master_1st] < 1) and ($_POST[master_2nd] < 1)){

$nvalue = "n_" . $_POST[master_tag];
$dvalue = "d_" . $_POST[master_tag];
$pvalue = "p_" . $_POST[master_tag];

//Insert into nascar_first table
$sql_del_2 = "ALTER TABLE `nascar_first`
DROP `$nvalue`,
DROP `$dvalue`,
DROP `$pvalue`
";

$result_2 = mysql_query($sql_del_2, $connection) or die ("Could not Execute query_2. Reason: ".mysql_error());

//Insert into nascar_second table
$sql_del_second = "ALTER TABLE `nascar_second`
DROP `$nvalue`,
DROP `$dvalue`,
DROP `$pvalue`
";

$result_second = mysql_query($sql_del_second, $connection) or die ("Could not Execute query_second. Reason: ".mysql_error());

//Insert into nascar 1st and 2nd if updated to a yes
} else if (($_POST[master_1st] == 1) or ($_POST[master_2nd] == 1)){
$nvalue = "n_" . $_POST[master_ins_tag];
$dvalue = "d_" . $_POST[master_ins_tag];
$pvalue = "p_" . $_POST[master_ins_tag];


//Insert into nascar_first table
$sql_update_2 = "ALTER TABLE `nascar_first`
ADD `$nvalue` VARCHAR( 10 ) NOT NULL,
ADD `$dvalue` VARCHAR( 30 ) NOT NULL,
ADD `$pvalue` INT( 3 ) NOT NULL
";

$result_2 = mysql_query($sql_update_2, $connection) or die ("Could not Execute query. Reason: ".mysql_error());

//Insert into nascar_second table
$sql_update_second = "ALTER TABLE `nascar_second`
ADD `$nvalue` VARCHAR( 10 ) NOT NULL,
ADD `$dvalue` VARCHAR( 30 ) NOT NULL,
ADD `$pvalue` INT( 3 ) NOT NULL
";

$result_second = mysql_query($sql_update_second, $connection) or die ("Could not Execute query. Reason: ".mysql_error());


//Insert new player name into n_ field
for ($i = 1; $i <= 18; $i++){
//Update first half table
$sql_insert_nvalue = "UPDATE nascar_first SET
$nvalue = '$_POST[master_ins_f_name]'
WHERE week = '$i'
";
//Run Query
$qry_insert_nvalue = mysql_query($sql_insert_nvalue, $connection) or die ("Can not execute insert Query");

$second_i = ($i + 18);
//Update second half table
$sql_insert_nvalue_2 = "UPDATE nascar_second SET
$nvalue = '$_POST[master_ins_f_name]'
WHERE week = '$second_i'
";
//Run Query
$qry_insert_nvalue_2 = mysql_query($sql_insert_nvalue_2, $connection) or die ("Can not execute insert_2 Query");

}//end the add field for NASCAR if

}  //end the update if

//Run Del Comment
if ($del_user == "yes") {

//Delete from nascar first and Nascar 2nd if user was a member of the Nascar
if (($master_1st == 1) or ($master_2nd == 1)){

$nvalue = "n_" . $_POST[master_tag];
$dvalue = "d_" . $_POST[master_tag];
$pvalue = "p_" . $_POST[master_tag];

//Insert into nascar_first table
$sql_del_2 = "ALTER TABLE `nascar_first`
DROP `$nvalue`,
DROP `$dvalue`,
DROP `$pvalue`
";

$result_2 = mysql_query($sql_del_2, $connection) or die ("Could not Execute query_2. Reason: ".mysql_error());

//Insert into nascar_second table
$sql_del_second = "ALTER TABLE `nascar_second`
DROP `$nvalue`,
DROP `$dvalue`,
DROP `$pvalue`
";

$result_second = mysql_query($sql_del_second, $connection) or die ("Could not Execute query_second. Reason: ".mysql_error());
} //end del if in nascar

$sql_del = "
DELETE FROM users WHERE user_id = '$_POST[master_user_id]'
";

$del_result = mysql_query($sql_del, $connection) or die ("Could not Delete query. Reason: ".mysql_error());


} //end del if

//run update
if ($run_master_insert == "new"){
$sql_check = "SELECT user_tag FROM users WHERE user_tag = '$_POST[master_ins_tag]'";
$sql_check_2 = "SELECT first_name FROM users WHERE first_name = '$_POST[master_ins_f_name]'";

$qry_check = mysql_query($sql_check, $connection) or die ("Could not execute check query");
$qry_check_2 = mysql_query($sql_check_2, $connection) or die ("Could not execute check 2 query");

$check_1 = mysql_num_rows($qry_check);
$check_2 = mysql_num_rows($qry_check_2);

if ($check_1 != 0) {
$info_block .= "<tr><td align='center'><font size='5' color='red'><strong>You already have a user with that tag, please select a different tag not taken.</strong></font></td></tr>";
} else if ($check_2 != 0) {
$info_block .= "<tr><td align='center'><font size='5' color='red'><strong>You already have a user with that Name, please select a different name.</strong></font></td></tr>";
} else if ($_POST[master_ins_tag] == NULL) {
$info_block .= "<tr><td align='center'><font size='5' color='red'><strong>You did not enter a User Tag value.  You need to enter a value to move on.</strong></font></td></tr>";
} else {

$sql_update = "INSERT INTO users
(user_tag, first_name, last_name, password, permission, email, fantasy_nascar, fantasy_nascar_2, fantasy_football)
VALUES
('$_POST[master_ins_tag]', '$_POST[master_ins_f_name]', '$_POST[master_ins_l_name]', '$_POST[master_ins_pass]', '$_POST[master_ins_per]', '$_POST[master_ins_email]', '$_POST[master_ins_1st]', '$_POST[master_ins_2nd]', '$_POST[master_ins_FF]')
";

$result = mysql_query($sql_update, $connection) or die ("Could not Execute query. Reason: ".mysql_error());

//Insert into Nascar 1st and 2nd if they want in Nascar
if (($_POST[master_1st] == 1) or ($_POST[master_2nd] == 1)){
$nvalue = "n_" . $_POST[master_ins_tag];
$dvalue = "d_" . $_POST[master_ins_tag];
$pvalue = "p_" . $_POST[master_ins_tag];


//Insert into nascar_first table
$sql_update_2 = "ALTER TABLE `nascar_first`
ADD `$nvalue` VARCHAR( 10 ) NOT NULL,
ADD `$dvalue` VARCHAR( 30 ) NOT NULL,
ADD `$pvalue` INT( 3 ) NOT NULL
";

$result_2 = mysql_query($sql_update_2, $connection) or die ("Could not Execute query. Reason: ".mysql_error());

//Insert into nascar_second table
$sql_update_second = "ALTER TABLE `nascar_second`
ADD `$nvalue` VARCHAR( 10 ) NOT NULL,
ADD `$dvalue` VARCHAR( 30 ) NOT NULL,
ADD `$pvalue` INT( 3 ) NOT NULL
";

$result_second = mysql_query($sql_update_second, $connection) or die ("Could not Execute query. Reason: ".mysql_error());


//Insert new player name into n_ field
for ($i = 1; $i <= 18; $i++){
//Update first half table
$sql_insert_nvalue = "UPDATE nascar_first SET
$nvalue = '$_POST[master_ins_f_name]'
WHERE week = '$i'
";
//Run Query
$qry_insert_nvalue = mysql_query($sql_insert_nvalue, $connection) or die ("Can not execute insert Query");

$second_i = ($i + 18);
//Update second half table
$sql_insert_nvalue_2 = "UPDATE nascar_second SET
$nvalue = '$_POST[master_ins_f_name]'
WHERE week = '$second_i'
";
//Run Query
$qry_insert_nvalue_2 = mysql_query($sql_insert_nvalue_2, $connection) or die ("Can not execute insert_2 Query");
} // end for loop

} //end insert into 1st and 2nd if

} //end check if

} // end the insert new if


//Get information from the table
$sql_get_info = "SELECT *
FROM users
ORDER BY user_id
";

$qry_get_info = mysql_query($sql_get_info, $connection) or die ("Could not get the proper info");

//Start of the display block for this page
$display_block = "<br>
<table align='center' border='1' cellspacing='1' width='770'>
<tr>
<th colspan='11' align='center'>Update Information for Players</th>
</tr>
<tr>
<td align='center'><strong>1st Name</strong></td>
<td align='center'><strong>Last Name</strong></td>
<td align='center'><strong>Last Login</strong></td>
<td align='center'><strong>User Tag</strong></td>
<td align='center'><strong>Pass</strong></td>
<td align='center'><strong>Email</strong></td>
<td align='center'><strong>Per</strong></td>
<td align='center'><strong>1st</strong></td>
<td align='center'><strong>2nd</strong></td>
<td align='center'><strong>FF</strong></td>
<td align='center'><strong>Update</strong></td>
<td align='center'><strong>Delete</strong></td>
</tr>";

while ($info = mysql_fetch_array($qry_get_info)) {
$master_user_id = $info[user_id];
$master_tag = $info[user_tag];
$master_f_name = $info[first_name];
$master_l_name = $info[last_name];
$master_ll = $info[last_login];
$master_pass = $info[password];
$master_email = $info[email];
$master_per = $info[permission];
$master_1st = $info[fantasy_nascar];
$master_2nd = $info[fantasy_nascar_2];
$master_FF = $info[fantasy_football];

//Continue the display block
$display_block .= "
<tr>
<form method='post' action='$_SERVER[PHP_SELF]'>
<td align='center'>
<input type='hidden' name='master_user_id' value='$master_user_id'>
<input type='hidden' name='master_tag' value='$master_tag'>
<input type='hidden' name='run_master_update' value='yes'>
$master_f_name</td>
<td align='center'><input type='text' name='master_l_name' value='$master_l_name' size='8'></td>
<td align='center'>$master_ll</td>
<td align='center'>$master_tag</td>
<td align='center'><input type='text' name='master_pass' value='$master_pass' size='6'></td>
<td align='center'><input type='text' name='master_email' value='$master_email' size='25'></td>
<td align='center'><input type='text' name='master_per' value='$master_per' size='1'></td>
<td align='center'><input type='text' name='master_1st' value='$master_1st' size='1'></td>
<td align='center'><input type='text' name='master_2nd' value='$master_2nd' size='1'></td>
<td align='center'><input type='text' name='master_FF' value='$master_FF' size='1'></td>
<td><input type='submit' name='submit' value='Update' size='10'></td></form>
<form method='post' action='$_SERVER[PHP_SELF]'><td>
<input type='hidden' name='del_user' value='yes'>
<input type='hidden' name='master_user_id' value='$master_user_id'>
<input type='hidden' name='master_tag' value='$master_tag'>
<input type='hidden' name='master_1st' value='$master_1st'>
<input type='hidden' name='master_2nd' value='$master_2nd'>
<input type='submit' name='submit' value='Delete' size='8'></td></form>
</form></tr>";

} // End While loop


//End the display block
$display_block .= "</table>";

$display_block .="<br>
<table align='center' border='1' cellspacing='2' width='770'>
<tr>
<th colspan='9' align='center'>Insert Information for New Players</th>
</tr>
<tr>
<td align='center'><strong>1st Name</strong></td>
<td align='center'><strong>Last Name</strong></td>
<td align='center'><strong>User Tag</strong></td>
<td align='center'><strong>Pass</strong></td>
<td align='center'><strong>Email</strong></td>
<td align='center'><strong>Per</strong></td>
<td align='center'><strong>1st</strong></td>
<td align='center'><strong>2nd</strong></td>
<td align='center'><strong>FF</strong></td>
<td align='center'><strong>Insert</strong></td>
</tr>
<tr><form method='post' action='$_SERVER[PHP_SELF]'>
<input type='hidden' name='run_master_insert' value='new'>
<td align='center'><input type='text' name='master_ins_f_name' size='6'></td>
<td align='center'><input type='text' name='master_ins_l_name' size='8'></td>
<td align='center'><input type='text' name='master_ins_tag' size='3'></td>
<td align='center'><input type='text' name='master_ins_pass' size='6'></td>
<td align='center'><input type='text' name='master_ins_email' size='25'></td>
<td align='center'><input type='text' name='master_ins_per' value='1' size='1'></td>
<td align='center'><input type='text' name='master_ins_1st' value='1'  size='1'></td>
<td align='center'><input type='text' name='master_ins_2nd' value='1'  size='1'></td>
<td align='center'><input type='text' name='master_ins_FF' value='1'  size='1'></td>
<td><input type='submit' name='submit' value='Add Player' size='6'></td>
</form></tr>
</table>";
?>
[/code]

[Jocka]

I just took a quick glance by under:
}//end the add field for NASCAR if

just add another
}

see if that does it.. looks like u might be missing one there

[komquat]

Yes, that was it, thank you so much, so frustrating when it is something like that