Registration form advice

Clint · #1 (**permalink**) August 26th, 2009, 05:44 AM

I wonder if somebody could put me on the right track with a registration form.
I have no problem creating the form, it all works fine. My problem is, if I want to create a registration form that people worldwide can register and is state/province specific.

For example: On the form you have the option to select what country you are from, and for this example you are from South Africa. Now if you select South Africa I want to be able to have another list that would show the 9 provinces of south africa, so you could select, say, KwaZulu Natal.
Or if you selected America, it would give you the option to select which of the 50 or so states you from. The state/province list should only show according to what country you are from.

Does that make sense?

I am not lazy or looking for somebody to write the whole thing out for me but maybe just guide on the right track?

thanks for your time!
Clint

om_prakash · #2 (**permalink**) August 26th, 2009, 09:13 AM

Please check the following links for similar info:
http://www.phpsimple.net/tutorials/d...dropdown_menu/
http://www.plus2net.com/php_tutorial..._down_list.php
http://www.plus2net.com/javascript_t...pdown-code.php

Clint · #3 (**permalink**) September 16th, 2009, 04:42 AM

Hello again...
Could somebody please advise me on the following (and bear with me...Im a newbie)
I was trying out this code for a dependant drop down list for country and state from this site:
http://javascript.internet.com/forms...drop-down.html

It works fine but when I use php to put selected options in the mysql tables I created and display the outcome it displays the country and state code and not the actual name.(for example: I select United Sates and Texas it will display US and TX instead of the whole name, so its saving the codes instead of the names) Im sure I am doing something small wrong but thats what you get for being a newb! I have tried to break down my code as much as possible and maybe somebody could help me in the right direction.

The javascript is at the address above and here is on my page:
this is the code on my page that creates the list boxes and it shows up fine:

Code:

 <td height="21" colspan="2" valign="top"><font color="#FF0000" size="1">Please 
              select your country/state</font> <font color="#FF0000">*</font></td>
            <td></td>
          </tr>
          <tr> 
            <td height="27" valign="top"> 
              <select id='countrySelect' name='country' class="required" onchange='populateState()'>
              </select>
            </td>
            <td valign="top"> 
              <select id='stateSelect' name='state'>
              </select>
              <script type="text/javascript">initCountry('PLS'); </script>
            <td></td>
          </tr>

Then I have this php to send it to mysql table (I am not including the whole page, just the php related to this problem):

Code:

mysql_query("UPDATE users SET
`country` = '$_POST[country]',
`state` = '$_POST[state]',
WHERE id='$_SESSION[user_id]'
") or die(mysql_error());

On the profile page it displays it with this php:

Code:

$result = mysql_query("select * from users where id='$_SESSION[user_id]'");

//grab all the content
while($r=mysql_fetch_array($result))
{	
   //the format is $variable = $r["nameofmysqlcolumn"];
   //modify these to match your mysql table columns
  

   $country=$r["country"];
   $state=$r["state"];

   
   //display the row
   echo " <br> $country <br> $state <br> ";
}

There is a row in the mysql table called country, varchar(200), not null
and the same for state called state.

Appologies in advance for the long post but I thought I better add all details I might need.
Thanks again for your time.

Clint

Need to download code?

Navigation