vbcoach

WAIT! Please read my post. Don't move! I asked about color coding a specific word INSIDE of a menu, not the entire menu. I already know how to do that, and I wrote in my initial posting!

How to color individual words of text inside drop-down menu? A question if you don't mind about coloring text in PHP output - this time inside of a drop-down menu. Do you know if it is possible to color code a single word or words of text in a drop-down menu? For example I have a list of shirt colors and sizes and would like to make the color of the t-shirt text be that color. For example Women's BLUE large - I would like the word "Blue" be in the color Blue if possible. Do you know if this is possible? If so, do you have an example of code that would work? I find codes that change the entire drop-down menu, but not individual words. Thanks in advance.

So I can just use $lateteam = '04/21/2011' and this will work?

Hello all. Trying this again. I would like to implement a simple math formula based on a date, but not sure how to do that exactly. I run a sports league, and want to calculate fees based upon a fixed date. Prior to 'some date' use this calculation, but after this date, add late fees using 2nd calculation. In my code there are two fields: $earlyteam and $lateteam. I need $lateteam to kick in after 'some date'. Help? //calculate Fees $size = $lSize['size']; switch($size) { case 2: $base = 150; $size = 3; break; case 4: $base = 330; $size = 6; break; case 6: $base = 550; $size = 10; break; default: die ("invalid league size"); }; $earlyTeam = $base; { $e_each = $earlyTeam / $pCount; $lateTeam = $earlyTeam * 1.10; $l_each = $lateTeam / $pCount; }

By the way, forgot to mention that date was April 15th, and the database is MS SQL. Hope this helps? Trying to figure out where date needs to be inserted and how for this loop to work properly. Should be relatively simple. thanks all.

Hello again. I run a sports league website and registrations received after a certain date need to have their league fees calculated to add 10%. someone wrote this for me a couple of years ago, but I have since then lost the full code. Need to know how to add a date to the follow statement that would automatically add the 10%. Can someone look at this for me and fill me in on what's missing? Thanks! /* * Calculate fees */ $intSize = intval($arrLeagueSearch['size']); switch($intSize) { case 2: $dblBase = 150.00; $intBSize = 3; break; case 4: $dblBase = 330.00; $intBSize = 6; break; case 6: $dblBase = 550.00; $intBSize = 10; break; default: die("Invalid league size"); }; $dblEarlyTeam = $dblBase; $dblEach = $dblEarlyTeam / $intPlayers; /* $dblLateTeam = $dblEarlyTeam * 1.10; $dblLateEach = $dblLateTeam / $intPlayers; */

FIXED! Just needed to do a </span> and I now have what I needed! Thanks for the refresher team! Much appreciated!

Ok, reloaded the code, now works BUT ***EVERYTHING*** past is now in red. I only wanted the results "(Locked)" to be in red. Nothing else. Were getting close. Help?

UNFORTUNATELY, no working if($team["locked"] == 1) { echo "<span style='color:red;'>(locked)</span>"; else { echo " "; } echo "<br>"; I get this error: Parse error: parse error, unexpected T_ELSE in E:\... php on line 61

Ok, I understand that. but when I tried, I received an error. Do I wrap it inside the quotes? Can you give me an example please? Thanks a bunch

Hello. Racking my brains here, having trouble with this. Running a sports league, trying to get the output of one variable at a different font color OR insert a simple check mark graphic. Either way I am stuck. I am a bit out of practice here. Here is the code. Where is says echo ( Locked) is where I would like to either have locked in a color, say green or red - or insert check mark symbol. <?php $last = -1; while($team = mssql_fetch_assoc($res)) { if ($last != $team['l_id']) { $last = $team['l_id']; echo "<br><span class=\"dk_greyTxt\" style=\"font-size: 14px\"><strong>$team[night] night, $team[type] $team[size]s $team[division]</strong></span><br><br>"; } echo "<strong>$team[teamname] - ($team[shirtcolor] shirts)</strong><br> RegDate: $team[reg_start]<br>RegDone: $team[reg_done]"; $cpt = mssql_query("SELECT firstname, lastname, shirtsize, feepaid, feememo FROM captain WHERE c_id = $team[captain]",$conn); $c = mssql_fetch_assoc($cpt); if($team["locked"] == 1) { echo " (Locked)"; } else { echo " "; } echo "<br>";

I find it amazing that not one single person can assist with this issue. I am sure the MsSql query is correct. It has to be in the PHP. I suspect my issue is somewhere in this statement. Would any body care to take a crack at this?

Hello. Have an issue that has been bugging me for a couple of weeks now that I am just not figuring out. I have a sports league site that has multiple leagues and divisions. I have a looping statement that queries the leagues, returns the leagues (nights and divisions) with the number of those teams that are paid and also "locked in". See screenshot #1 attached. I have 4 queries written that are working properly when run from Sql Management Studio with the correct results displayed. $query2 = "SELECT l_id, COUNT(*) as num_teams FROM league as l, team WHERE league = l_id AND reg_done != '' GROUP BY l_id,type,size,l.division,night ORDER BY l_id"; $paidTeams = mssql_query($query2,$conn); $query3 = "SELECT l.type, l.[size], l.division, l.l_id, l.[session], COUNT(*) AS num_teams FROM league as l, team WHERE team.league = l.l_id AND (l.[session] = 'Summer') GROUP BY l.l_id, l.type, l.[size], l.division, l.night, l.[session] ORDER BY l.l_id"; $leagues2 = mssql_query($query3,$conn); $query4 = "SELECT l.type, l.[size], l.division, l.l_id, l.[session], COUNT(*) AS num_teams FROM league as l, team WHERE team.league = l.l_id AND (l.[session] = 'Summer') AND reg_done != '' GROUP BY l.l_id, l.type, l.[size], l.division, l.night, l.[session] ORDER BY l.l_id"; $paidTeams2 = mssql_query($query4,$conn); $query5 = "SELECT l.type, l.[size], l.division, l.l_id, l.[session], COUNT(*) AS num_teams FROM league as l, team WHERE team.league = l.l_id AND (l.[session] = 'Summer') and team.locked = '1' GROUP BY l.l_id, l.type, l.[size], l.division, l.night, l.[session] ORDER BY l.l_id"; $lockedteams = mssql_query($query5,$conn); These results display correctly in MsSql, but not on my page. No error is generated, just no results displayed, so I must concede that my code is wrong. I could use your help discovering where my mistake is, and correct it. There are currently 3 "locked in" teams: 2 in M4A Division and 1 in M4B Division. Here is my PHP code: <?php $paidt2 = mssql_fetch_assoc($paidTeams2); $lockedt = mssql_fetch_assoc($lockedteams); while($row = mssql_fetch_assoc($leagues2)) { ?> <tr> <td><?php echo "$row[type] $row[size] $row[division]" ?></td> <td><div align="center"><?php echo $row['num_teams']; ?></div></td> <td><div align="center"> <?php if($row['l_id'] == $paidt2['l_id']) { echo "<strong> $paidt2[num_teams]</strong>"; $paidt2 = mssql_fetch_assoc($paidTeams2); $lockedt = mssql_fetch_assoc($lockedteams); } else echo '-'; ?> </div></td> <td><div align="center"> <?php if($row['l_id'] == $lockedt['l_id']) { echo "<strong> $lockedt[num_teams]</strong>"; $paidt2 = mssql_fetch_assoc($paidTeams2); $lockedt = mssql_fetch_assoc($lockedteams); } else echo '-'; ?> </div></td> <td width="10"> </td> </tr> <?php } ?> Many thanks for your assistance! [attachment deleted by admin]

I can't believe not one person can help me with this sql query?

Hello and thanks for your help. I have a sports league database that contains 3 tables: Team, Captain, and Player. I am trying to order t-shirts for all captains and players for this league. I did not create this database. Here's the dilema; The TEAM table contains the shirt color for the team (column name is 'shirtcolor') The CAPTAIN table contains the team captain and his shirt size (column name is 'shirtsize') and finally the PLAYER table (column name is 'pshirt') for the player shirt size. What I need to do is create a query to gather and display all the shirts, broken down by color and size for both the captains and players. The creator of the database wrote a query a while back for the players shirts that works. Here is the code for the players shirts that works: SELECT t.shirtcolor, p.pshirt, COUNT(t.shirtcolor) as shirt_count FROM team as t, player as p WHERE t.t_id = p.team AND t.locked = 1 GROUP BY t.shirtcolor, p.pshirt ORDER BY shirtcolor, pshirt What I need to do is to come up with a query for ALL shirts (not just the players) and dawg-gone it, I just can't figure out how to do it. Can anyone help? Thanks in advance!

That did it. Not sure why the variable had to be (re)called, but thanks a bunch!

I hate to be a pain, but again it is defined here in access.php <?php mssql_close($conn); exit; } $SBteam = mssql_fetch_assoc($res); $_SESSION['id'] = $SBteam['player_id']; $_SESSION['playername'] = $SBteam['playername'];

Sure there is. In the included code: access.php Here's the flow: *Index page allows player to enter his userid and password. *Access.php processes that information, sets $_Post variables to pass to *viewplayer.php which allows player to view his current information. *editplayer.php allows a player to change certain fields. *updateplayer.php processes those changes, then updates the variables. It's at this point where the "id" is not being found. If I do a $vars = get_defined_vars(); print_r($vars); it does show an "[id] = 1" which is what the player_id is supposed to be. I am confused.

Here you go. <?php require_once('access.php'); $info = $_SESSION; ?> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>Baltimore Beach Control Panel</title> <link rel="stylesheet" href="../../cp/cpanel.css" type="text/css"> <script language="javascript"> </script> <style type="text/css"> <!-- .style2 { font-size: 18px; font-weight: bold; } .style5 {font-size: 14; font-weight: bold; } .style7 {font-size: 14px; } --> </style> </head> <body> <p><img src="images/trinity1.jpg" width="336" height="87"></p> <table width="788" border="0" cellspacing="1" cellpadding="1"> <tr> <td width="58%" height="340"><form name="updtplyr" action="updatePlayer.php" method="post"> <table width="98%" border="0" cellpadding="2" cellspacing="0" class="grey2px"> <tr> <td colspan="3" class="dk_greyTxt"><h3 class="style2">Player's Information</h3></td> </tr> <tr> <td width="30%" class="dk_greyTxt"><span class="style5">Name</span></td> <td width="3%"> </td> <td width="67%"><?php echo $info['playername']; ?> </td> </tr> <tr> <td class="dk_greyTxt"><span class="style5">Home Phone</span></td> <td> </td> <td><input type="text" name="homephone" id="homephone" value="<?php echo $info['homephone'] ?>"> <br></td> </tr> <tr> <td class="dk_greyTxt"><span class="style5">Cell Phone</span></td> <td> </td> <td><input type="text" name="cellphone" id="cellphone" value="<?php echo $info['cellphone'] ?>"></td> </tr> <tr> <td class="dk_greyTxt"><span class="style5">E-mail</span></td> <td> </td> <td><input type="text" name="email" id="email" value="<?php echo $info['email'] ?>"></td> </tr> <tr> <td class="dk_greyTxt"><span class="style5">Jersey</span></td> <td> </td> <td><?php echo $info['jersey'] ?></td> </tr> <tr> <td class="dk_greyTxt"><span class="style5">Position 1</span></td> <td> </td> <td><input type="text" name="position1" id="position1" value="<?php echo $info['position1'] ?>"></td> </tr> <tr> <td class="dk_greyTxt"><span class="style5">Position 2</span></td> <td> </td> <td><input type="text" name="position2" id="position2" value="<?php echo $info['position2'] ?>"></td> </tr> <tr> <td class="dk_greyTxt"><span class="style5">Position 3</span></td> <td> </td> <td><input type="text" name="position3" id="position3" value="<?php echo $info['position3'] ?>"></td> </tr> <tr> <td class="dk_greyTxt"><span class="style5">Comments</span></td> <td rowspan="2" valign="top"> </td> <td rowspan="2" valign="top"><textarea name="comments" id="comments" cols="45" rows="2"><?php echo $info['comments'] ?></textarea> </td> </tr> <tr> <td class="dk_greyTxt"> </td> </tr> <tr> <td class="dk_greyTxt"> </td> <td> </td> <td><input type="submit" name="updateplayerinfo" id="updateplayerinfo" value="Update Player Information"> </td> </tr> </table> <br> </form> </td> <td width="42%" align="center" valign="top"><form name="uAv" action="updateAvailability.php" method="post" > <table width="310" border="0"> <tr> <td colspan="10" bgcolor="#D1E39B"><div align="center" class="style2">Schedule Availability</div></td> </tr> <tr> <td width="59" class="menu"><div align="center" class="style7">5/1</div></td> <td width="58" class="menu"><div align="center" class="style7">5/8</div></td> <td width="58" class="menu"><div align="center" class="style7">5/15</div></td> <td width="58" class="menu"><div align="center" class="style7">5/22</div></td> <td width="55" class="menu"><div align="center" class="style7">5/29</div></td> </tr> <tr> <td><div align="center"> <select name="week6" id="week2"> > <option value="" <?php if($info['week1'] == NULL) echo 'selected'; ?>>?</option> <option value="Yes" <?php if($info['week1'] == 'Yes') echo 'selected'; ?>>Yes</option> <option value="No" <?php if($info['week1'] == 'No') echo 'selected'; ?>>No</option> </select> </div></td> <td><div align="center"> <select name="week6" > <option value="" <?php if($info['week2'] == NULL) echo 'selected'; ?>>?</option> <option value="Yes" <?php if($info['week2'] == 'Yes') echo 'selected'; ?>>Yes</option> <option value="No" <?php if($info['week2'] == 'No') echo 'selected'; ?>>No</option> </select> </div></td> <td><div align="center"> <select name="week6" id="week6"> <option value="" <?php if($info['week3'] == NULL) echo 'selected'; ?>>?</option> <option value="Yes" <?php if($info['week3'] == 'Yes') echo 'selected'; ?>>Yes</option> <option value="No" <?php if($info['week3'] == 'No') echo 'selected'; ?>>No</option> </select> </div></td> <td><div align="center"> <select name="week6" id="week7"> <option value="" <?php if($info['week4'] == NULL) echo 'selected'; ?>>?</option> <option value="Yes" <?php if($info['week4'] == 'Yes') echo 'selected'; ?>>Yes</option> <option value="No" <?php if($info['week4'] == 'No') echo 'selected'; ?>>No</option> </select> </div></td> <td><div align="center"> <select name="week6" id="week8"> <option value="" <?php if($info['week5'] == NULL) echo 'selected'; ?>>?</option> <option value="Yes" <?php if($info['week5'] == 'Yes') echo 'selected'; ?>>Yes</option> <option value="No" <?php if($info['week5'] == 'No') echo 'selected'; ?>>No</option> </select> </div></td> </tr> </table> <p> <table width="310" border="0"> <tr> <td colspan="10" bgcolor="#D1E39B"><div align="center" class="style2">Schedule Availability</div></td> <tr> <td width="59" class="menu"><div align="center" class="style7">6/5</div></td> <td width="58" class="menu"><div align="center" class="style7">6/12</div></td> <td width="58" class="menu"><div align="center" class="style7">6/19</div></td> <td width="58" class="menu"><div align="center" class="style7">6/26</div></td> <td width="55" class="menu"><div align="center" class="style7">7/10</div></td> </tr> <tr> <td><div align="center"> <select name="week6" id="week9"> <option value="" <?php if($info['week6'] == NULL) echo 'selected'; ?>>?</option> <option value="Yes" <?php if($info['week6'] == 'Yes') echo 'selected'; ?>>Yes</option> <option value="No" <?php if($info['week6'] == 'No') echo 'selected'; ?>>No</option> </select> </div></td> <td><div align="center"> <select name="week7" id="week10"> <option value="" <?php if($info['week7'] == NULL) echo 'selected'; ?>>?</option> <option value="Yes" <?php if($info['week7'] == 'Yes') echo 'selected'; ?>>Yes</option> <option value="No" <?php if($info['week7'] == 'No') echo 'selected'; ?>>No</option> </select> </div></td> <td><div align="center"> <select name="week8" id="week11"> <option value="" <?php if($info['week8'] == NULL) echo 'selected'; ?>>?</option> <option value="Yes" <?php if($info['week8'] == 'Yes') echo 'selected'; ?>>Yes</option> <option value="No" <?php if($info['week8'] == 'No') echo 'selected'; ?>>No</option> </select> </div></td> <td><div align="center"> <select name="week9" id="week12"> <option value="" <?php if($info['week9'] == NULL) echo 'selected'; ?>>?</option> <option value="Yes" <?php if($info['week9'] == 'Yes') echo 'selected'; ?>>Yes</option> <option value="No" <?php if($info['week9'] == 'No') echo 'selected'; ?>>No</option> </select> </div></td> <td><div align="center"> <select name="week10" id="week13"> <option value="" <?php if($info['week10'] == NULL) echo 'selected'; ?>>?</option> <option value="Yes" <?php if($info['week10'] == 'Yes') echo 'selected'; ?>>Yes</option> <option value="No" <?php if($info['week10'] == 'No') echo 'selected'; ?>>No</option> </select> </div></td> </tr> </table> <p> <input type="submit" name="update" id="update" value="Update Availability"> <br> </p> </form> </form></td> </tr> </table> <p> </p> <p> </p> </body> </html> ============ This is the form that calls the update to be set in Sql database=============== ============= Now below is the ACCESS form that is used, and defines the variables ========== <?php /* This document will be used to manage the Trinity SB team sessions when they login This should be placed at the top of each page in the /trinitySB directory */ session_start(); if(!isset($_SESSION['id']) && !isset($_POST['unique'])) { //build login page again ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>Baltimore Beach Control Panel</title> <link rel="stylesheet" href="../cp/cpanel.css" type="text/css"> </head> <body> <table width="800" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3"><img src="../cp/images/BBV_CP_top.jpg" width="800" height="200"></td> </tr> <tr> <td> </td> <td><br> <br> <br> <form name="bbv_login_form" action="login.php" autocomplete = "false" method="post"> <table width="350" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td colspan="4"><img src="../cp/images/login_top.jpg" width="350" height="25"></td> </tr> <tr> <td width="5" rowspan="7" class="tableltBg"></td> <td colspan="2" align="center"><strong><em>Sorry: You must first login to use this feature </em></strong></td> <td width="5" rowspan="7" class="tableRtBg"></td> </tr> <tr> <td align="right" class="dk_greyTxt"> </td> <td> </td> </tr> <tr> <td width="100" align="right" class="dk_greyTxt"><strong>username: </strong></td> <td width="240"> <input name="unique" type="text" id="unique"></td> </tr> <tr> <td width="100"> </td> <td width="240"> </td> </tr> <tr> <td width="100" align="right" class="dk_greyTxt"><strong>password: </strong></td> <td width="240"> <input name="pword" type="password" id="pword"></td> </tr> <tr> <td> </td> <td> </td> </tr> <tr> <td width="100"> </td> <td width="240"><input name="Submit" type="submit" class="button" value="Login"></td> </tr> <tr> <td colspan="4" class="tableFoot"></td> </tr> </table> </form> </td> <td> </td> </tr> <tr> <td colspan="3"> </td> </tr> </table> </body> </html> <?php exit; } if(isset($_POST['pword'])) { $conn = mssql_connect ("localhost", "bbpublic", "********") or die ('I cannot connect to the database because: ' . mssql_error()); $un = $_POST['unique']; $pw = $_POST['pword']; mssql_select_db("baltimorebeach"); $sql = "SELECT t.*, username, password FROM trinitySBteam as t WHERE username='$un' AND password='$pw'"; $res = mssql_query($sql,$conn); if(mssql_rows_affected($conn) !== 1) { //Login unsuccessful build nessecery page ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>Trinity Softball 2010 Control Panel</title> <link rel="stylesheet" href="../cp/cpanel.css" type="text/css"> </head> <body> <table width="800" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3"><img src="../cp/images/BBV_CP_top.jpg" width="800" height="200"></td> </tr> <tr> <td> </td> <td><br> <br> <br> <form name="bbv_login_form" action="" autocomplete = "false" method="post"> <table width="350" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td colspan="4"><img src="../cp/images/login_top.jpg" width="350" height="25"></td> </tr> <tr> <td width="5" rowspan="7" class="tableltBg"></td> <td colspan="2" align="center"><strong><em>Error: username/password combination not found </em></strong></td> <td width="5" rowspan="7" class="tableRtBg"></td> </tr> <tr> <td align="right" class="dk_greyTxt"> </td> <td> </td> </tr> <tr> <td width="100" align="right" class="dk_greyTxt"><strong>username: </strong></td> <td width="240"> <input name="unique" type="text" id="unique"></td> </tr> <tr> <td width="100"> </td> <td width="240"> </td> </tr> <tr> <td width="100" align="right" class="dk_greyTxt"><strong>password: </strong></td> <td width="240"> <input name="pword" type="password" id="pword"></td> </tr> <tr> <td> </td> <td> </td> </tr> <tr> <td width="100"> </td> <td width="240"><input name="Submit" type="submit" class="button" value="Login"></td> </tr> <tr> <td colspan="4" class="tableFoot"></td> </tr> </table> </body> </html> <?php mssql_close($conn); exit; } $SBteam = mssql_fetch_assoc($res); $_SESSION['id'] = $SBteam['player_id']; $_SESSION['playername'] = $SBteam['playername']; $_SESSION['homephone'] = $SBteam['homephone']; $_SESSION['cellphone'] = $SBteam['cellphone']; $_SESSION['email'] = $SBteam['email']; $_SESSION['jersey'] = $SBteam['jersey']; $_SESSION['position1'] = $SBteam['position1']; $_SESSION['position2'] = $SBteam['position2']; $_SESSION['position3'] = $SBteam['position3']; $_SESSION['week1'] = $SBteam['week1']; $_SESSION['week2'] = $SBteam['week2']; $_SESSION['week3'] = $SBteam['week3']; $_SESSION['week4'] = $SBteam['week4']; $_SESSION['week5'] = $SBteam['week5']; $_SESSION['week6'] = $SBteam['week6']; $_SESSION['week7'] = $SBteam['week7']; $_SESSION['week8'] = $SBteam['week8']; $_SESSION['week9'] = $SBteam['week9']; $_SESSION['week10'] = $SBteam['week10']; $_SESSION['week11'] = $SBteam['week11']; $_SESSION['week12'] = $SBteam['week12']; $_SESSION['comments'] = $SBteam['comments']; mssql_close($conn); } ?> There is one other page that simply allows the player to view his current information. Does this help?

You are right! The variable is not there. However when I do a vardump, the "id" exists and returns the correct value. Any thoughts?

Hello. Have a simple site that takes softball player names and after successful logging in, give them to edit some basic information, like home and cell phone, comments, etc.. Everything appears correct, yet I am getting an undefined index MsSql error, yet when I do a variable dumb, the index appears. Not sure what I am doing wrong. <?php require_once('access.php'); $conn = mssql_connect ("localhost", "bbpublic", "hdyet65e42") or die ('I cannot connect to the database because: ' . mssql_error()); mssql_select_db("********"); $vals = $_POST; $sql = "UPDATE trinitySBteam SET homephone='$vals[homephone]',cellphone='$vals[cellphone]',email='$vals[email]',position1='$vals[position1]',position2='$vals[position2]',position3='$vals[position3]',comments='$vals[comments]' WHERE player_id = $vals[id]"; mssql_query($sql, $conn); mssql_close($conn); //Update Session Variables $_SESSION['homephone'] = $vals['homephone']; $_SESSION['cellphone'] = $vals['cellphone']; $_SESSION['email'] = $vals['email']; $_SESSION['position1'] = $vals['position1']; $_SESSION['position2'] = $vals['position2']; $_SESSION['position3'] = $vals['position3']; $_SESSION['comments'] = $vals['comments']; header("Location: viewplayer.php"); ?> Yet I get this error after running... Notice: Undefined index: id in E:\Web Server\baltimorebeach_com\htdocs\trinitySB\updatePlayer.php on line 15 Warning: mssql_query(): message: Line 1: Incorrect syntax near '='. (severity 15) in E:\Web Server\baltimorebeach_com\htdocs\trinitySB\updatePlayer.php on line 16 Warning: mssql_query(): Query failed in E:\Web Server\baltimorebeach_com\htdocs\trinitySB\updatePlayer.php on line 16 Warning: Cannot modify header information - headers already sent by (output started at E:\Web Server\baltimorebeach_com\htdocs\trinitySB\updatePlayer.php:15) in E:\Web Server\baltimorebeach_com\htdocs\trinitySB\updatePlayer.php on line 28

I have spent nearly a week "trying" this code of Antrum's. Once again it still does not work. If it worked, then I might be able to adapt it to my needs. However I do not understand either CDONTS or Antrum's code or what is wrong. There is an error in the "try" statement.

Hello? Anyone? Buehler?

Matthew, that's the problem. I do not know how to do that with CDONTS! No idea whatsoever. That is why I am here. Really needing some assistance here.

Ok, let me start over. Again, a registration page for a sports website (http://www.baltimorebeach.com/registration/teamregistration2010.php) is used for team captains to register their team. When complete, it goes to a processing page when the input is dumped into the database and a receipt page is displayed on the screen, which the captain is instructed to print out for his records as it contains all of his team's information, including his username and password to access the site (which of course the 'male' captains never do). We get dozens of emails a week asking for UN and PW requests because they were not sent a confirmation email. Duh. We haven't created one. yes I could create a reset password page, but it would be so much easier just to send the team captains a copy of their information via when registering. My hope is to take this "information" page and send it to the team captain via the email address he entered for the captain. My code is this: <?php if($_POST) { foreach ($_POST as $k=>$v) { $t = stripslashes($v); $t = str_replace("'",'′',$t); $vals[$k] = $t; } //Connect to Database $conn = mssql_connect ("localhost", "********", "********") or die ('I cannot connect to the database because: '); mssql_select_db("baltimorebeach"); $teamname = "SELECT t_id FROM team WHERE league = '$vals[league]' AND teamname='$vals[teamname]'"; $tres = mssql_query($teamname); if(mssql_rows_affected($conn) != 0) { $lsql = "SELECT * FROM league WHERE active = 1 AND [session] = 'Spring' ORDER BY l_id"; $lres = mssql_query($lsql,$conn); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>2010 Team Registration Complete</title> <link rel="stylesheet" href="dh2styles.css" type="text/css"> <script language="javascript"> function isEmail(str) { // are regular expressions supported? var supported = 0; if (window.RegExp) { var tempStr = "a"; var tempReg = new RegExp(tempStr); if (tempReg.test(tempStr)) supported = 1; } if (!supported) return (str.indexOf(".") > 2) && (str.indexOf("@") > 0); var r1 = new RegExp("(@.*@)|(\\.\\.)|(@\\.)|(^\\.)"); var r2 = new RegExp("^.+\\@(\\[?)[a-zA-Z0-9\\-\\.]+\\.([a-zA-Z]{2,3}|[0-9]{1,3})(\\]?)$"); return (!r1.test(str) && r2.test(str)); } function validate (theForm) { var errStr = ""; if(theForm.teamname.value == '') { errStr += "Team name not entered\n"; } if(theForm.league.value == -1) { errStr += "Please select a league in which to participate\n"; } if(theForm.shirtsize.value == -1) { errStr += "Please select a t-shirt color\n"; } if(!isEmail(theForm.cpt_email.value)) { errStr += "Please enter a valid e-mail address\n"; } if(theForm.cpt_first.value=='' || theForm.cpt_last.value=='') { errStr += "Captain's name incomplete\n"; } if(theForm.cpt_address.value=='' || theForm.cpt_city.value==''|| theForm.cpt_state.value== -1 || theForm.cpt_zip.value=='') { errStr += "Captain's address incomplete\n"; } if(theForm.cpt_shirtsize.value == -1) { errStr += "Please select a shirt size for the captain"; } if(errStr != "") { alert("The following problems have occurred\n\n"+errStr); return false; } return true; } </script> <style type="text/css"> <!-- .style8 { color: #FF0000; font-size: 18px; } .style9 {color: #000000} a:link { color: #000000; } a:visited { color: #000000; } --> </style> </head> <body> <h4 align="center"> <img src="http://www.baltimorebeach.com/images/oops3.gif" alt="Oops! Team Name Already In Use" /> </h4> <h4 align="center" class="style5"><span class="style4">Team name </span><strong><em>"<span class="style7 style8"><?= $vals['teamname'] ?></span>"</em> already taken for this league! Please selecet a different name</strong>. </h4> <h4 align="center"><p align="center" class="style9">Please press <a href="javascript:history.back()">Back</a> on your browser and choose a different team name </p> </h4> </body> </html> <?php mssql_close($conn); exit; }//if team name already exists //League Info $leagueId = $vals['league']; $leagueRes = mssql_query("SELECT * FROM league WHERE l_id = $leagueId",$conn); $lSize = mssql_fetch_assoc($leagueRes); //Create the captain $ln = strtolower(substr($vals['cpt_first'],0,1).str_replace("'","",$vals['cpt_last'])); $loginSQL = "SELECT COUNT(*) FROM captain WHERE username LIKE '$ln%'"; $lres = mssql_query($loginSQL,$conn); $count = mssql_fetch_row($lres); //login is first initial + last name $login = strtolower(substr($vals['cpt_first'],0,1).str_replace("'","",$vals['cpt_last'])).substr($lSize['type'],0,1).$lSize['size'].$lSize['division']; if($count[0] > 0) { $login = strtolower(substr($vals['cpt_first'],0,1).str_replace("'","",$vals['cpt_last']).$count[0].substr($lSize['type'],0,1).$lSize['size'].$lSize['division']); } $password = strtolower(substr($vals['cpt_first'],0,1).substr($vals['cpt_last'],0,1).substr($vals['cpt_phone'],-4)); $cpt_sql = "INSERT INTO captain (username,password,firstname,lastname,address,city,state,zip,email,phone,shirtsize,returningteam,rteamname) VALUES ('$login','$password','$vals[cpt_first]','$vals[cpt_last]','$vals[cpt_address]','$vals[cpt_city]','$vals[cpt_state]','$vals[cpt_zip]','$vals[cpt_email]','$vals[cpt_phone]','$vals[cpt_shirtsize]','$vals[returningteam]','$vals[rteamname]')"; //run captain query $query = mssql_query($cpt_sql,$conn); //Find the captains id # for the team information $query = mssql_query("SELECT c_id FROM captain ORDER BY c_id DESC;",$conn); $qRes = mssql_fetch_assoc($query); $cptId = $qRes['c_id']; //$cptId = 1; //---------- $getip = $_SERVER['REMOTE_ADDR']; //Create the team $team_sql = "INSERT INTO team (teamname,shirtcolor,league,captain,venue,ip) VALUES ('$vals[teamname]','$vals[shirtcolor]','$leagueId','$cptId','$vals[venue]','$getip')"; //echo $team_sql; //run team query $query = mssql_query($team_sql,$conn); //find team id for players $query1 = mssql_query("SELECT t_id FROM team ORDER BY t_id DESC;",$conn); $qRes = mssql_fetch_assoc($query1); $teamId = $qRes['t_id']; //------------------ //build players /* loop through all ten possible players listed and check to see if the name field has at least 2 characters. If it does then we will grab the other 3 bits of information and add the player to the database. */ $players = ''; $pCount = 1; $members = $leagueId == 31 ? 6:11; for($i =1; $i <= $members; $i++) { if(strlen($vals['player'.$i.'_name']) > 2) { $pName = $vals['player'.$i.'_name']; $pEmail = $vals['player'.$i.'_email']; $ppShirt = $vals['player'.$i.'_shirt']; $pCount ++; $p_sql = "INSERT INTO player (name,email,team,pshirt) VALUES ('$pName','$pEmail','$teamId','$ppShirt')"; $query = mssql_query($p_sql,$conn); $players .= "$pName - $ppShirt <br />\n"; } } //------------- mssql_close($conn); //calculate Fees $size = $lSize['size']; switch($size) { case 2: $base = 150; $size = 3; break; case 4: $base = 330; $size = 6; break; case 6: $base = 550; $size = 10; break; default: die ("invalid league size"); }; $earlyTeam = $base; { $e_each = $earlyTeam / $pCount; $lateTeam = $earlyTeam * 1.10; $l_each = $lateTeam / $pCount; } //POST everything else - time to display more variables echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>2010 Summer Session Team Registration Confirmation</title> <link rel="stylesheet" href="jahstyles.css" type="text/css"> </head> <body> '; echo " <div id=\"banner\"> <img border=\"0\" src=\"bbeachlogo.jpg\"> <h3>Team $vals[teamname] Registration for \"Spring\" Leagues 2010!</h3> <p <font face=\"Comic Sans MS\">Thank you for registering with Baltimore Beach, please <strong><a href=\"javascript:window.print()\">PRINT</a></strong> this page for your records.<br> <strong>Registration is not considered complete until team fees have been paid.</strong><br> Please send one check for team fees, as captain, this responsibility falls to you.<br><br> To view all other teams that have registered in your league <a href=\"http://www.baltimorebeach.com/spring2010leagueinfo.php?l=$lSize[l_id]\">click here</a> <h2><b><u>Team Captain Info:</u></b></h2> <strong>Name</strong>: $vals[cpt_first] $vals[cpt_last]<br> <strong>Address</strong>: $vals[cpt_address] $vals[cpt_city], $vals[cpt_state] $vals[cpt_zip]<br> <strong>Email</strong>: $vals[cpt_email]<br> <strong>Shirt</strong>: $vals[cpt_shirtsize]<br> <strong>Login</strong>: $login<br> <strong>Password</strong>: $password<br> Captain's web page is: <a href=\"http://www.baltimorebeach.com/cp\">http://www.baltimorebeach.com/cp</a> <h2><b><u>Team Info:</u></b></h2> <strong>BBV League</strong>: Spring $lSize[night] $lSize[type] $lSize[size] $lSize[division]<br> <strong>Team Name</strong>: $vals[teamname]<br> <strong>T-Shirt Color</strong>: $vals[shirtcolor]<br> <strong>No. of Players</strong>: $pCount<br> <strong>Team Fees Due</strong>: \$$earlyTeam<br> </p> <p> <h2><b><u>Players / Shirt Sizes:</u></b></h2> $players </p> <p> <p><span class=\"style99\">Make (one) team registration check payable to</span><strong>:</strong> <span class=\"style34\">Baltimore Beach</span> <br /> <span class=\"style98\">*Please enter team name, league night & division on memo line</span></p> <p align=\"left\"><span class=\"style99\">Send to</span><strong>:</strong> <span class=\"style33\">Baltimore Beach<br /> 1317 S. Hanover Street <br /> Baltimore, MD 21230</span></p> <p align=\"left\"><span class=\"style33\">*** League payments now accepted via PayPal ***</span><br> <a href=\"http://www.baltimorebeach.com/paypal.htm\" target=\"_self\"><img src=\"http://www.baltimorebeach.com/images/paypal.jpg\" width=\"150\" height=\"52\" hspace=\"61\" border=\"0\" longdesc=\"http://www.baltimorebeach.com/images/paypal.jpg\"></a><br> <img src=\"http://www.baltimorebeach.com/images/paypal2.jpg\" width=\"148\" height=\"17\" hspace=\"62\" vspace=\"0\" longdesc=\"http://www.baltimorebeach.com/images/paypal2.jpg\"></p> </div> </body> </html> "; } /* */ ?> Please keep in mind that I am not an experienced PHP programmer. I inherited this already-existing project. Thanks in advance for any assistance. My only option for sending email via the hosting provider is using CDONTS (CDO)