Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > Beginning PHP
Beginning PHP Beginning-level PHP discussions. More advanced coders should post to the Pro PHP forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning PHP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 26th, 2009, 05:44 AM
Authorized User
Join Date: Aug 2009
Posts: 12
Thanks: 1
Thanked 0 Times in 0 Posts
Question Registration form advice

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!
Old August 26th, 2009, 09:13 AM
Friend of Wrox
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts

Please check the following links for similar info:
Om Prakash Pant
Click the "Thanks" button if this post helped you.
The Following User Says Thank You to om_prakash For This Useful Post:
Clint (August 27th, 2009)
Old September 16th, 2009, 04:42 AM
Authorized User
Join Date: Aug 2009
Posts: 12
Thanks: 1
Thanked 0 Times in 0 Posts

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:

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:

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

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:

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

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


   //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.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a registration form gertho1 BOOK: Beginning ASP.NET 2.0 and Databases 1 April 6th, 2009 02:16 PM
problem in registration form prashant_telkar ASP.NET 1.x and 2.0 Application Design 5 July 11th, 2007 01:09 AM
problem with trigger in registration form prashant_telkar SQL Server 2000 2 July 9th, 2007 06:52 PM
Registration Form Help invisible bunny king Classic ASP Databases 7 February 5th, 2007 05:30 PM
Multiple registration ok??? TheMole BOOK: ASP.NET Website Programming Problem-Design-Solution 7 July 31st, 2005 04:26 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.