komquat Posted November 29, 2006 Share Posted November 29, 2006 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 408Meaning missing syntax. I have looked for 24 hours and can not find. Help is appreciated.[code=php:0]<?//Session Startingsession_start(); if ($_SESSION[level] != "full_admin") { header("location:http://www.andybourdeau.com/"); exit; }include("include/connection.php");//Update the information if neededif ($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 Commentif ($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 updateif ($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] Quote Link to comment Share on other sites More sharing options...
Jocka Posted November 29, 2006 Share Posted November 29, 2006 I just took a quick glance by under:}//end the add field for NASCAR ifjust add another}see if that does it.. looks like u might be missing one there Quote Link to comment Share on other sites More sharing options...
komquat Posted November 29, 2006 Author Share Posted November 29, 2006 Yes, that was it, thank you so much, so frustrating when it is something like that Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.