Abscooters

Thank you again.

Oh I really like the last way, that works excellent. Thank you!! It still shows the disabled values, that is cool. IS there a way to highlight either the selected or unselected with removeClass('highlight') or addClass('highlight') I had text input with onblur verification before, which still allowed duplicates to be submitted, this works so much better.

I knew about the repopulating problem, that is why I asked for a reset button. It is all better than what I had before.

Thanks again Barand, that works in IE, FF and chrome. Doesn't work in opera, but not many of them users only, just flag a browser warning I have a mobile version, should I change visibility to display for that? I wish they all handled js the same.

OK I implemented it, and it works in firefox & chrome but not on IE or mobile devices. Is there a work around for them?

Thank you Barand so much!!!!!

My Bad, I forgot to include the script source. Thank you so much, this is what I have been looking for. I can modify that to do what I need it to do. It works really good, is there a way to add a button that resets them all to unselected and unhidden without refreshing the page.

I am fresh to PHP and understand even less java and ajax. Thank you for the script. How do I call the script from the compiled drop downs so that they change when one is selected, am I missing something.

I'm looking for a way to have 5 different select menus. Each one pre-php-populated with the same data to begin with. Lets say numbers 1 through 5. If user selects #2 in any of the lists, all the other lists #2 will dissapear from. With ultimately only one unique selection in each list (1 through 5). Like having a list of 5 things to do and a select list next to each one to select the priority in which it gets done. Is there a way to do this with ajax?

have been doing websites for a few years, mostly all open source joomla, oscommerce, phpBB, smf. Our main business is http://absolutelyscooters.net but during the fall and winter months I try to develop, maintain and upgrade the websites I host. I turned to this forum as I do a fair amount of modifying plugins, add-ons and components and really would like to learn more about PHP, Java and AJAX and their integration with HTML. Dave

Oh didn't see the code block tags, here is the file. <?php require_once('includes/application_top.php'); require('includes/classes/team.php'); if ($_POST['action'] == 'Submit') { $week = $_POST['week']; $cutoffDateTime = getCutoffDateTime($week); //update summary table $sql = "delete from " . $db_prefix . "picksummary where weekNum = " . $_POST['week'] . " and userID = " . $user->userID . ";"; mysql_query($sql) or die('Error updating picks summary: ' . mysql_error()); $sql = "insert into " . $db_prefix . "picksummary (weekNum, userID, showPicks) values (" . $_POST['week'] . ", " . $user->userID . ", " . (int)$_POST['showPicks'] . ");"; mysql_query($sql) or die('Error updating picks summary: ' . mysql_error()); //loop through non-expire weeks and update picks $sql = "select * from " . $db_prefix . "schedule where weekNum = " . $_POST['week'] . " and (DATE_ADD(NOW(), INTERVAL " . SERVER_TIMEZONE_OFFSET . " HOUR) < gameTimeEastern and DATE_ADD(NOW(), INTERVAL " . SERVER_TIMEZONE_OFFSET . " HOUR) < '" . $cutoffDateTime . "');"; $query = mysql_query($sql); while ($result = mysql_fetch_array($query)) { $sql = "delete from " . $db_prefix . "picks where userID = " . $user->userID . " and gameID = " . $result['gameID']; mysql_query($sql) or die('Error deleting picks: ' . mysql_error()); if (!empty($_POST['game' . $result['gameID']])) { $sql = "insert into " . $db_prefix . "picks (userID, gameID, pickID) values (" . $user->userID . ", " . $result['gameID'] . ", '" . $_POST['game' . $result['gameID']] . "); update " . $db_prefix . "picks SET 'points' = ". (int)$_POST['points' . $result['gameID']] ." WHERE 'userID' = ". $user ." and 'gameID' = ". $result['gameID'] ." LIMIT 1 ;"; mysql_query($sql) or die('Error inserting pick: ' . mysql_error()); } } header('Location: results.php?week=' . $_POST['week']); } else { $week = (int)$_GET['week']; if (empty($week)) { //get current week $week = (int)getCurrentWeek(); } $cutoffDateTime = getCutoffDateTime($week); $firstGameTime = getFirstGameTime($week); } include('includes/header.php'); include('includes/column_right.php'); //display week nav $sql = "select distinct weekNum from " . $db_prefix . "schedule order by weekNum;"; $query = mysql_query($sql); $weekNav = '<div class="navbar3"><b>Go to week:</b> '; $i = 0; while ($result = mysql_fetch_array($query)) { if ($i > 0) $weekNav .= ' | '; if ($week !== (int)$result['weekNum']) { $weekNav .= '<a href="entry_form.php?week=' . $result['weekNum'] . '">' . $result['weekNum'] . '</a>'; } else { $weekNav .= $result['weekNum']; } $i++; } $weekNav .= '</div>' . "\n"; echo $weekNav; ?> <!-- <table cellpadding="0" cellspacing="0"> <tr valign="top"> <td width="60%"> //--> <h2>Week <?php echo $week; ?> - Make Your Picks:</h2> <p>Make your picks below by clicking on the team helmet or checking the radio buttons to the right.</p> <script type="text/javascript"> function checkform() { //make sure all picks have a checked value var f = document.entryForm; var allChecked = true; var allR = document.getElementsByTagName('input'); for (var i=0; i < allR.length; i++) { if(allR[i].type == 'radio') { if (!radioIsChecked(allR[i].name)) { allChecked = false; } } } if (!allChecked) { return confirm('One or more picks are missing for the current week. Do you wish to submit anyway?'); } return true; } function radioIsChecked(elmName) { var elements = document.getElementsByName(elmName); for (var i = 0; i < elements.length; i++) { if (elements[i].checked) { return true; } } return false; } </script> <div style="float: right; width: 270px; margin-right: 10px"><?php include('includes/comments.php'); ?></div> <?php //get existing picks $picks = getUserPicks($week, $user->userID); $points = array(); $points = $picks; //get show picks status $sql = "select * from " . $db_prefix . "picksummary where weekNum = " . $week . " and userID = " . $user->userID . ";"; $query = mysql_query($sql); if (mysql_num_rows($query) > 0) { $result = mysql_fetch_array($query); $showPicks = (int)$result['showPicks']; } else { $showPicks = 1; } //display schedule for week $sql = "select s.*, (DATE_ADD(NOW(), INTERVAL " . SERVER_TIMEZONE_OFFSET . " HOUR) > gameTimeEastern or DATE_ADD(NOW(), INTERVAL " . SERVER_TIMEZONE_OFFSET . " HOUR) > '" . $cutoffDateTime . "') as expired "; $sql .= "from " . $db_prefix . "schedule s "; $sql .= "inner join " . $db_prefix . "teams ht on s.homeID = ht.teamID "; $sql .= "inner join " . $db_prefix . "teams vt on s.visitorID = vt.teamID "; $sql .= "where s.weekNum = " . $week . " "; $sql .= "order by s.gameTimeEastern, s.gameID"; //echo $sql; $query = mysql_query($sql); if (mysql_num_rows($query) > 0) { echo '<form name="entryForm" action="entry_form.php" method="post" onsubmit="return checkform();">' . "\n"; echo '<input type="hidden" name="week" value="' . $week . '" />' . "\n"; echo '<table cellpadding="4" cellspacing="0" class="table1">' . "\n"; //echo ' <tr><th>Home</th><th>Visitor</th><th align="left">Game</th><th>Time / Result</th><th>Your Pick</th></tr>' . "\n"; $i = 0; while ($result = mysql_fetch_array($query)) { $homeTeam = new team($result['homeID']); $visitorTeam = new team($result['visitorID']); $rowclass = (($i % 2 == 0) ? ' class="altrow"' : ''); //$pickExpired = ((date("U") > strtotime($result['gameTimeEastern'])) ? true : false); echo ' <tr' . $rowclass . '>' . "\n"; echo ' <td align="center">' . "\n"; echo ' <table width="100%" border="0" cellpadding="2" cellspacing="0" class="nostyle">' . "\n"; echo ' <tr valign="middle">' . "\n"; echo ' <td align="center"><label for="' . $result['gameID'] . $visitorTeam->teamID . '"><img src="images/helmets_big/' . strtolower($visitorTeam->teamID) . '1.gif" onclick="document.entryForm.game' . $result['gameID'] . '[0].checked=true;" /></label><br /><span style="font-size: 9px;"><b>' . $visitorTeam->city . ' ' . $visitorTeam->team . '</b><br />Record: ' . getTeamRecord($visitorTeam->teamID) . '<br />Streak: ' . getTeamStreak($visitorTeam->teamID) . '</span></td>' . "\n"; echo ' <td align="center">at</td>' . "\n"; echo ' <td align="center"><label for="' . $result['gameID'] . $homeTeam->teamID . '"><img src="images/helmets_big/' . strtolower($homeTeam->teamID) . '2.gif" onclick="document.entryForm.game' . $result['gameID'] . '[1].checked=true;" /></label><br /><span style="font-size: 9px;"><b>' . $homeTeam->city . ' ' . $homeTeam->team . '</b><br />Record: ' . getTeamRecord($homeTeam->teamID) . '<br />Streak: ' . getTeamStreak($homeTeam->teamID) . '</span></td>' . "\n"; echo ' </tr>' . "\n"; if (strlen($result['homeScore']) > 0 && strlen($result['visitorScore']) > 0) { //if score is entered, show score echo ' <tr><td colspan="3" align="center"><b>Final: ' . $result['visitorScore'] . ' - ' . $result['homeScore'] . '</b></td></tr>' . "\n"; } else { //else show time of game echo ' <tr><td colspan="3" align="center">' . date('D n/j g:i a', strtotime($result['gameTimeEastern'])) . ' ET</td></tr>' . "\n"; } echo ' </table>' . "\n"; echo ' </td>' . "\n"; echo ' <td align="left"><b>Your Pick:</b><br />' . "\n"; if (!$result['expired']) { //if game is not expired, show pick echo ' <input type="radio" name="game' . $result['gameID'] . '" value="' . $visitorTeam->teamID . '" id="' . $result['gameID'] . $visitorTeam->teamID . '"' . (($picks[$result['gameID']]['pickID'] == $visitorTeam->teamID) ? ' checked="checked"' : '') . ' /> <label for="' . $result['gameID'] . $visitorTeam->teamID . '">' . $visitorTeam->teamName . '</label><br />' . "\n"; echo ' <input type="radio" name="game' . $result['gameID'] . '" value="' . $homeTeam->teamID . '" id="' . $result['gameID'] . $homeTeam->teamID . '"' . (( $picks[$result['gameID']]['pickID'] == $homeTeam->teamID) ? ' checked="checked"' : '') . ' /> <label for="' . $result['gameID'] . $homeTeam->teamID . '">' . $homeTeam->teamName . '</label><br />' . "\n"; echo ' <input type="number" min="1" max="15" name="points' . $result['gameID'] . '" value="' . $picks[$result['gameID']]['points'] . '"/><br />' . "\n"; } else { //else show locked pick $pickID = getPickID($result['gameID'], $user->userID); if (!empty($pickID)) { $statusImg = ''; $pickTeam = new team($pickID); $pickLabel = $pickTeam->teamName; } else { $statusImg = '<img src="images/cross_16x16.png" width="16" height="16" alt="" />'; $pickLabel = 'None Selected'; } if ($scoreEntered) { //set status of pick (correct, incorrect) if ($pickID == $result['winnerID']) { $statusImg = '<img src="images/check_16x16.png" width="16" height="16" alt="" />'; } else { $statusImg = '<img src="images/cross_16x16.png" width="16" height="16" alt="" />'; } } echo ' ' . $statusImg . ' ' . $pickLabel . "\n"; } echo ' </td>' . "\n"; echo ' </tr>' . "\n"; $i++; } echo '</table>' . "\n"; echo '<p><input type="checkbox" name="showPicks" id="showPicks" value="1"' . (($showPicks) ? ' checked="checked"' : '') . ' /> <label for="showPicks">Allow others to see my picks</label></p>' . "\n"; echo '<p><input type="submit" name="action" value="Submit" /></p>' . "\n"; echo '</form>' . "\n"; } ?> <!-- </td> <td width="40%"> <h2>Latest Comments:</h2> <p>comment</p> <div> </div> </td> </tr> </table> //--> <?php include('includes/footer.php'); ?>

the table is for an office pool of weekly nfl picks, based on PHPPick'em. The table picks has the structure of userid, gameid, pickid and points (integer default = 1). There is one row for each user for each game. I want to implement instead of points being 1 for each game, the user selects 1 through 15 (or however many games there are that week). I am having trouble getting this form to pass points to the table and also need to find something to validate it. This file displays the ones (default value) perfectly after picks are made, but it doesn't pass the points from the html input to the table. I am very new to PHP, and usually am able to modify others code to adapt to my needs, but I am really stuck on this one, any help would be greatly appreciated. entry_formweighted.php I tried multiple ways putting it into the Insert statement, and this last one I tried putting it into an update statement after the insert, not having any luck.