Im using a Dynamic Dependent Select Box within my jQuery validation form, although i have ran into a problem in regards to the remote check. 

Firstly, i will explain the process of the Select Box.

An example,

Select Box 1 contains a list of countries: England, America, Australia. Once a user selects one of these countries, it will then populate the second select box with the cities within that country. Then the third select box will populate the towns within that city. 

What i have currently got now is the script checking the database with raw results. 

This is my javascript:

As you can see List1, List2, and List3 are the select box's. Once the user selects the option from the third select box (List3) it will then run a php script to check the database (im not sure if this is the proper way of doing it). 

1. <script type="text/javascript">
2.  $(function(){
3.      $("#register_form").validate({ 
4. debug: false,
5. rules: {
6. List1: { required: true }, 
7. List2: { required: true }, 
8. List3: { required: true, remote: "check-team.php" }, 
9.          firstname: { required: true, maxlength: 14 },
10.          lastname: { required: true, maxlength: 14 },
11.          email: { maxlength: 32, remote: "check_email.php" },
12.          mobile: { required: true, minlength: 10, number: true, remote: "check_mobile.php" },
13.          password: { required: true, maxlength: 14 },
14.          password2: { required: true, equalTo: "#password" }
15.      },
16.     messages: {
17.    List3:{ remote: "Team already registered." },
18.         email:{ remote: "Already subscribed" },
19.         mobile:{ remote: "Mobile already registered." }
20.      },
21.     submitHandler: function(form) {
22. // do other stuff for a valid form
23. $.post('process.php', $("#register_form").serialize(), function(data) {
24. $('.results').html(data);
25. });
26. }
27. }); 
28.  });
29. </script>

In my database i have 3 fields Country, City, Towns. The php script checks to see if the Country, City and Town have been registered as a whole unit. 

1. <?php include 'database.php'; ?>
2. 
   
3. <?php
4. 
   
5. $List1 = mysql_real_escape_string($_REQUEST['List1']);
6. $List2 = mysql_real_escape_string($_REQUEST['List2']);
7. $List3 = mysql_real_escape_string($_REQUEST['List3']);
8. 
   
9. $sql = "SELECT COUNT(id) FROM users WHERE `country` = '".$List1."' AND `city` = '".$List2."' AND `town` = '".$List3."'";
10. $results = mysql_query($sql) or die(mysql_error());
11. 
    
12. if (mysql_result($results, 0) > 0) {
13. echo "false";
14.          } else {
15.          echo "true";
16.          }
17. ?>

Im not sure if I am doing this the right way but it doesn't seem to be working, although if i change the variables to raw existing data like this:

$List1 = 'Australia';

$List2 = 'Sydney';

$List3 = 'Newtown';

Doing it this way does seem to work. But using the request seems to have some kind of problem...

Here is my html aswell:

1. <form id="register_form" action="#" method="POST">
2. <table width="200" class="tableregister" cellpadding="7">
3. 
   
4. <tr>
5. <td valign="top"><input id="lastname" name="lastname" type="text" placeholder="Full Name" /></td>
6. 
   
7. <td valign="top"><input id="email" class="email required" name="email" type="text" placeholder="Email Address" /></td>
8. </tr>
9. <tr>
10. <td valign="top">
11. <select id="List1" name='List1' onchange="fillSelect(this.value,this.form['List2'])" >
12. <option value=''selected>Choose Region</option>
13. </select>
14. </td>
15. <td valign="top"><input id="mobile" type="text" name="mobile" placeholder="Mobile Number"/></td>
16. </tr>
17. <tr>
18. <td valign="top">
19. <select id="List2" name='List2' onchange="fillSelect(this.value,this.form['List3'])">
20. <option value=''selected>Choose Club</option>
21. </select>
22. </td>
23. <td valign="top"><input id="password" name="password" type="password" placeholder="Password" /></td>
24. </tr>
25. <tr>
26. <td valign="top">
27. <select id="List3" name='List3' onchange="getValue(this.value, this.form['List2'].value, this.form['List1'].value)">
28. <option value=''selected>Choose Club</option>
29. </select>
30. </td>
31. <td valign="top"><input id="password2" name="password2" type="password" placeholder="Repeat Password" /></td>
32. </tr>
33. 
    
34. 
    
35. </table>
36. 
    
37. </form>

Any help would be much appreciated. Thankyou so much.

Cheers