Tournament sorting form

Hi, I have created a simple form that the users of my site will use to register to a tournament. The users have to be logged to the site and have to select a number from 1 to 90 in a dropdown list. I want that once a number has been chosen and the form has been sent it should disappear from the list or be unavailable for another user. How can I do?

Thanks in advance for your help.


Here is the HTML code

<?php 
$user =& JFactory::getUser();
?>

<div class="form_item">
  <div class="form_element cf_text"> <span class="cf_text">Modulo Iscrizione</span> </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Scegli Un Numero!</label>
    <select class="cf_inputbox validate-selection" id="select_1" size="1" title=""  name="select_1">
    <option value="">Seleziona</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>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
<option value="37">37</option>
<option value="38">38</option>
<option value="39">39</option>
<option value="40">40</option>
<option value="41">41</option>
<option value="42">42</option>
<option value="43">43</option>
<option value="44">44</option>
<option value="45">45</option>
<option value="46">46</option>
<option value="47">47</option>
<option value="48">48</option>
<option value="49">49</option>
<option value="50">50</option>
<option value="51">51</option>
<option value="52">52</option>
<option value="53">53</option>
<option value="54">54</option>
<option value="55">55</option>
<option value="56">56</option>
<option value="57">57</option>
<option value="58">58</option>
<option value="59">59</option>
<option value="60">60</option>
<option value="61">61</option>
<option value="62">62</option>
<option value="63">63</option>
<option value="64">64</option>
<option value="65">65</option>
<option value="66">66</option>
<option value="67">67</option>
<option value="68">68</option>
<option value="69">69</option>
<option value="70">70</option>
<option value="71">71</option>
<option value="72">72</option>
<option value="73">73</option>
<option value="74">74</option>
<option value="75">75</option>
<option value="76">76</option>
<option value="77">77</option>
<option value="78">78</option>
<option value="79">79</option>
<option value="80">80</option>
<option value="81">81</option>
<option value="82">82</option>
<option value="83">83</option>
<option value="84">84</option>
<option value="85">85</option>
<option value="86">86</option>
<option value="87">87</option>
<option value="88">88</option>
<option value="89">89</option>
<option value="90">90</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_button">
    <input value="Invia" name="button_2" type="submit" />
  </div>
  <div class="cfclear"> </div>
</div>
<input type="hidden" name="user_nome" value="<?php echo $user->name; ?>" /> 

Hi bolamite,

Link the form to a table with the DB Connection. Let's assume that the table is jos_my_table and the column name for the record is 'select_1' and its type is INT (i.e. it is stored as a number).

<?php
$db =& JFactory::getDBO();
$query = "
    SELECT DISTINCT `select_1`
        FROM `#__my_table`
        ORDER BY `select_1`;
";
$db->setQuery($query);
$used = $db->loadResultList();
$option_array = array_diff(range(1, 90), $used);
$options = array('' => 'Seleziona');
foreach ( $option_array as $v ) {
  $options[] = "<option value='{$v}' >{$v}</option>";
}
?>
. . .
<select class="cf_inputbox validate-selection" id="select_1" size="1" title="" name="select_1">
<?php echo implode('', $options); ?>
</select>
. . .

Not tested and may need debugging

Bob

Thank you GreyHead, I'll try it asap and I'll let you know if it works.