chrisidas

I've tried both of the above and still no closer to figuring it out. Is it actually possible to get values, with the way that my <select> and <option> are created? I think the reason they are created like that is because i use JavaScript to show and hide them on the page.

Cheers guys, will give it a go

What do you mean? How would i go about changing it so i could get the values in my script?

Hey, I have a form which includes drop down boxes that show a list of options from my database. The problem i have is, i use a function to create my <options>, and they all have the same <select> name, so i have no idea how to fetch them in my form script. Here's my code to make the options, thanks to Nightslyr <?php function makeSelects($dbResult) { mysql_data_seek($dbResult, 0); while($row = mysql_fetch_assoc($dbResult)) { echo "<option value='{$row['playername']}'>{$row['playername']}</option>"; } } function homeScorers($dbResult) { echo '<select name="homeScorers[]" class="hidden-home" >'; makeSelects($dbResult); echo '</select>'; } function awayScorers($dbResult) { echo '<select name="awayScorers[]" class="hidden-away" >'; makeSelects($dbResult); echo '</select>'; } function homeYellowCards($dbResult) { echo '<select name="homeYellowCards[]" class="hidden-home" >'; makeSelects($dbResult); echo '</select>'; } function awayYellowcards($dbResult) { echo '<select name="awayYellowCards[]" class="hidden-away" >'; makeSelects($dbResult); echo '</select>'; } function homeRedCards($dbResult) { echo '<select name="homeRedCards[]" class="hidden-home" >'; makeSelects($dbResult); echo '</select>'; } function awayRedCards($dbResult) { echo '<select name="awayRedCards[]" class="hidden-away" >'; makeSelects($dbResult); echo '</select>'; } $homeQuery = "SELECT * FROM players WHERE teamname = '$hometeam'"; $homeResult = mysql_query($homeQuery); $awayQuery = "SELECT * FROM players WHERE teamname = '$awayteam'"; $awayResult = mysql_query($awayQuery); ?> and here's the code for the form <form action="result-script.php" method="post" name="myForm"> <table class="post-result" border="0" cellspacing="0" cellpadding="10"> <tr> <td class="post-result-home"><?php echo $hometeam ?> <input type="hidden" name="hometeam" value="<?php echo $hometeam ?>"> </td> <td class="post-result-away"><?php echo $awayteam ?> <input type="hidden" name="awayteam" value="<?php echo $awayteam ?>"> </td> </tr> <tr> <td class="post-result-home">Home Goals <select name="homescore" id="homescore"> <?php for($a = 0; $a < 11; ++$a) { echo "<option value='$a'>$a</option>"; } ?> </select> </td> <td class="post-result-away"> <select name="awayscore" id="awayscore"> <?php for($a = 0; $a < 11; ++$a) { echo "<option value='$a'>$a</option>"; } ?> </select> Away Goals</td> </tr> <tr> <td class="post-result-home"> <?php for($i = 0; $i < 10; ++$i) { homeScorers($homeResult); } ?></td> <td class="post-result-away"> <?php for($i = 0; $i < 10; ++$i) { awayScorers($awayResult); } ?> </td> </tr> <tr> <td class="post-result-home">Home Yellow Cards <select name="homeyellowcards" id="homeyellowcards"> <?php for($a = 0; $a < 11; ++$a) { echo "<option value='$a'>$a</option>"; } ?> </select></td> <td class="post-result-away"><select name="awayyellowcards" id="awayyellowcards"> <?php for($a = 0; $a < 11; ++$a) { echo "<option value='$a'>$a</option>"; } ?> </select> Away Yellow Cards</td> </tr> <tr> <td class="post-result-home"> <?php for($i = 0; $i < 10; ++$i) { homeYellowCards($homeResult); } ?></td> <td class="post-result-away"> <?php for($i = 0; $i < 10; ++$i) { awayYellowCards($awayResult); } ?> </td> </tr> <tr> <td class="post-result-home">Home Red Cards <select name="homeredcards" id="homeredcards"> <?php for($a = 0; $a < 11; ++$a) { echo "<option value='$a'>$a</option>"; } ?> </select></td> <td class="post-result-away"><select name="awayredcards" id="awayredcards"> <?php for($a = 0; $a < 11; ++$a) { echo "<option value='$a'>$a</option>"; } ?> </select> Away Red Cards</td> </tr> <tr> <td class="post-result-home"> <?php for($i = 0; $i < 10; ++$i) { homeRedCards($homeResult); } ?></td> <td class="post-result-away"> <?php for($i = 0; $i < 10; ++$i) { awayRedCards($awayResult); } ?> I've tried various ways of getting the result in my script but they all return errors. How would i make it so if two options are selected for say"homeScorers", i can set them as different variables in my form script. Cheers

Haha, hopefully i can sort it from here Cheers for taking some time to help a newbie like me

Awesome, that works now yeah. Last problem (hopefully), is when i have them hidden, they still dont show when the number for home goals and away goals are changed

Cheers buddy

<?php function makeSelects($dbResult) { while($row = mysql_fetch_assoc($dbResult)) { echo "<option value='{$row['playername']}'>{$row['playername']}</option>"; } } function homeScorers($dbResult) { echo '<select name="homeScorer[]" class="goalscorers" >'; makeSelects($dbResult); echo '</select>'; } function awayScorers($dbResult) { echo '<select name="awayScorer[]" class="goalscorers" >'; makeSelects($dbResult); echo '</select>'; } $homeQuery = "SELECT * FROM players WHERE teamname = '$hometeam'"; $homeResult = mysql_query($homeQuery); $awayQuery = "SELECT * FROM players WHERE teamname = '$awayteam'"; $awayResult = mysql_query($awayQuery); ?> <form action="result-script.php" method="post" id="myForm"> <table class="post-result" border="0" cellspacing="0" cellpadding="10"> <tr> <td class="post-result-home"><?php echo $hometeam ?> <input type="hidden" name="hometeam" value="<?php echo $hometeam ?>"> </td> <td class="post-result-away"><?php echo $awayteam ?> <input type="hidden" name="awayteam" value="<?php echo $awayteam ?>"> </td> </tr> <tr> <td class="post-result-home">Home Goals <select name="homescore" id="homescore"> <option value="0" selected="selected">0</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> <option value="8">8</option> <option value="9">9</option> <option value="10">10</option> </select> </td> <td class="post-result-away"><select name="awayscore" id="awayscore"> <option value="0" selected="selected">0</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> <option value="8">8</option> <option value="9">9</option> <option value="10">10</option> </select> Away Goals</td> </tr> <tr> <td class="post-result-home"> <p>Goal Scorers</p> <?php for($i = 0; $i < 10; ++$i) { homeScorers($homeResult); } ?></td> <td class="post-result-away"> <p>Goal Scorers<p> <?php for($i = 0; $i < 10; ++$i) { awayScorers($awayResult); } ?></td> </tr> <tr> <td colspan="2" class="post-result-submit"><input type="submit" value="Submit" /></td> </tr> </table> </form> <script> var homeScore = document.getElementById('homescore'); var awayScore = document.getElementById('awayscore'); homeScore.onchange = function() { var homeScorers = document.forms["myForm"].elements["homeScorer[]"]; var homeLength = homeScorers.length; for(var i = 0; i < homeLength; ++i) { homeScorers[i].display = "none"; } var score = this.value; for(var j = 0; j < score; ++j) { homeScorers[j].display = "block"; } } awayScore.onchange = function() { var awayScorers = document.forms["myForm"].elements["awayScorer[]"]; var awayLength = awayScorers.length; for(var i = 0; i < awayLength; ++i) { awayScorers[i].display = "none"; } var score = this.value; for(var j = 0; j < score; ++j) { awayScorers[j].display = "block"; } } </script>

That works to add more yeah, and to hide them. The problem i know have is the 1st drop down box shows all the players, then the next 9 dont have anything in :-\ Also, i cant seem to get it to change the number it shows when i change the score in the form. I've tried tweaking little bits in the script but not sure what needs changing tbh.

Thats worked now yeah Now i have this <?php function makeSelects($dbResult) { while($row = mysql_fetch_assoc($dbResult)) { echo "<option value='{$row['playername']}'>{$row['playername']}</option>"; } } function homeScorers($dbResult) { echo '<select name="homeScorer[]" >'; makeSelects($dbResult); } function awayScorers($dbResult) { echo '<select name="awayScorer[]" >'; makeSelects($dbResult); } $homeQuery = "SELECT * FROM players WHERE teamname = '$hometeam'"; $homeResult = mysql_query($homeQuery); $awayQuery = "SELECT * FROM players WHERE teamname = '$awayteam'"; $awayResult = mysql_query($awayQuery); ?> Then to display my drop down boxes in my form i use <tr> <td class="post-result-home"> <?php echo homeScorers($homeResult); ?> </td> <td class="post-result-away"> <?php echo awayScorers($awayResult); ?> </td> </tr> It now shows 1 drop down box for the home scorers, and one drop down box for the away scorers. So now i need to make it so it shows say, 10 drop down boxers for both home and away, then hide them with CSS? I tried doing this, but not sure how to do it. I added more of these <?php echo homeScorers($homeResult); ?> but nothing happened. I also added more of these echo "<option value='{$row['playername']}'>{$row['playername']}</option>"; but that didnt change anything either. Stuck again

Ok, so i think i'm starting to get my head around this now i've read it through properly and taken my time. This is the code i now have before my HTML <?php function makeSelects($dbResult) { while($row = mysql_fetch_assoc($dbResult)) { // make select OPTIONS, not the select tag $homeplayername = $row['playername']; ?> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <?php } while($row = mysql_fetch_assoc($dbResult)) { $awayplayername = $row['playername']; ?> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <?php } } function homeScorers($dbResult) { echo '<select name="homeScorer[]" >'; makeSelects($dbResult); } function awayScorers($dbResult) { echo '<select name="awayScorer[]" >'; makeSelects($dbResult); } $homeQuery = "SELECT * FROM players WHERE teamname = '$hometeam'"; $homeResult = mysql_query($homeQuery); $awayQuery = "SELECT * FROM players WHERE teamname = '$awayteam'"; $awayResult = mysql_query($awayQuery); ?> Is this correct? One thing i still dont understand is $dbResult. Do i need to change this to $homeResult and $awayResult? If that isnt the case, how would i associate the select options with the select tags?

Aaaaaaaah, I'm starting to get what you mean now

in function makeSelects($dbResult) should it look like this? <?php function makeSelects($dbResult) { while($row = mysql_fetch_assoc($dbResult) { homeScorers($homeResult); } } ?> and be placed where i want the drop down boxes to appear? Or would it look like this function makeSelects($dbResult) { while($row = mysql_fetch_assoc($dbResult) { ?> <option value="<?php echo $homeResult; ?>"><?php echo $homeResult; ?></option> <?php } } ?> Or am I way off again? Really am struggling to get my head around this lol

Thanks mate, will give this a go in a bit. Really appreciate the help

This is the code i have so far <script type="text/javascript"> <!-- var homescore = document.getElementById('homescore'); var awayscore = document.getElementById('awayscore'); homescore.onchange = function() { <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$hometeam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="homescorers" id="homescorers"> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <? }?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$hometeam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="homescorers" id="homescorers"> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <? }?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$hometeam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="homescorers" id="homescorers"> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <? }?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$hometeam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="homescorers" id="homescorers"> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <? }?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$hometeam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="homescorers" id="homescorers"> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <? }?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$hometeam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="homescorers" id="homescorers"> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <? }?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$hometeam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="homescorers" id="homescorers"> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <? }?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$hometeam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="homescorers" id="homescorers"> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <? }?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$hometeam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="homescorers" id="homescorers"> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <? }?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$hometeam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="homescorers" id="homescorers"> <option value="<?php echo $homeplayername; ?>"><?php echo $homeplayername; ?></option> <? }?> // unhide the number of child drop downs equal to this.value } awayscore.onchange = function() { // do the same thing here <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$awayteam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="awayscorers" id="awayscorers"> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <? } ?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$awayteam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="awayscorers" id="awayscorers"> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <? } ?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$awayteam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="awayscorers" id="awayscorers"> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <? } ?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$awayteam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="awayscorers" id="awayscorers"> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <? } ?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$awayteam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="awayscorers" id="awayscorers"> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <? } ?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$awayteam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="awayscorers" id="awayscorers"> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <? } ?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$awayteam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="awayscorers" id="awayscorers"> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <? } ?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$awayteam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="awayscorers" id="awayscorers"> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <? } ?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$awayteam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="awayscorers" id="awayscorers"> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <? } ?> <? $sql = mysql_query("SELECT * FROM players WHERE teamname='$awayteam'"); echo '<select name="playername" id="playername">'; while($row = mysql_fetch_array($sql)){ $homeplayername = $row['playername']; ?> <form method="post" action="result-script.php"> <select name="awayscorers" id="awayscorers"> <option value="<?php echo $awayplayername; ?>"><?php echo $awayplayername; ?></option> <? } ?> } //--> </script> Not sure if that's in anyway correct, but what would i have to add to it so that it shows the hidden options. Also, how would i call the code?