0

Hello every one,
i have a form with drop down list of month,dates,year. and text fields. i am able to insert the text fields values fine, but could not insert values from the dropdownlist(month,date,year) using same method. please could someone help me.below is my code.

<?php
 session_start();session_destroy();
 session_start();
if($_GET["firstname"] && $_GET["lastname"] && $_GET["email"] ["password"] && $_GET["repassword"])
{
    if($_GET["password"]==$_GET["repassword"])
    {
    $servername="";
    $username="";
    $password="";

    $conn=  mysql_connect($servername,$username,$password)or die(mysql_error());
    mysql_select_db("m",$conn);

    $firstname = mysql_real_escape_string( stripslashes( $_POST[ 'firstname' ] ) );
    $lastname  = mysql_real_escape_string( stripslashes( $_POST[ 'lastname' ] ) );
    $email     = mysql_real_escape_string( stripslashes( $_POST[ 'email' ] ) );
    $password  = mysql_real_escape_string( stripslashes( $_POST[ 'passowrd' ] ) );
    $address   = mysql_real_escape_string( stripslashes( $_POST[ 'address' ] ) );
    $month     = mysql_real_escape_string( stripslashes( $_POST[ 'month' ] ) );
    $date      = mysql_real_escape_string( stripslashes( $_POST[ 'date' ] ) );
    $year      = mysql_real_escape_string( stripslashes( $_POST[ 'year' ] ) );
    $sql="insert into datas (firstname,lastname,email,password,address,month,date,year)values('$_GET[firstname]','$_GET[lastname]','$_GET[email]','$_GET[password]','$_GET[address]','$_GET[month]','$_GET[date]','$_GET[year]')";
    $result=mysql_query($sql,$conn) or die(mysql_error());      
    print "<h1>you have registered sucessfully</h1>";

    print "<a href='index.php'>go to login page</a>";
    }
    else print "passwords doesnt match";
}
else print"invaild input data";

?>
5
Contributors
13
Replies
18
Views
4 Years
Discussion Span
Last Post by onofej
Featured Replies
  • 1

    Hi again, I'm not angry, but I can be a bit grumpy at times :) Sorry if I sounded abrupt earlier. Im not entirely sure why you have included the session calls at the top of the page as the code you showed doesn't use sessions. I have removed this … Read More

0

Firstly, I think that password may have been mistyped where you accept the user's input to the variable, $password.
I would suggest using a date type field in your table and construct a variable to contain the date, in the format yyyy-mm-dd. I think that's how I have done it.

0

Hi onofej,

You seem to be mixing $_GET and $_POST variables. What 'method' does your form use to send the data? GET or POST? Could you post the code for the form so we can check it through.

Edited by Zagga

0

Please see my comments commented on your code

<?php
 session_start();session_destroy();
 session_start();
 /**
 * 1. $_POST AND GET INTERCHANGE
 *    The the condition in your if statement expects HTTP get method, but inside
 *    your if block, it processes sent Post data with the password and repassword. 
 *    I assume you have iunintentionally interchange both $_GET and $_POST. This
 *    also is a security risk, sending sensitive data in a get method. This will,
 *    show the data in clear text format in the URL address bar once the form's
 *    submitted.
 * 2. ASSESING TWO DIMENSIONAL ARRAY IN IF STATEMENT
 *    $_GET["email"] ["password"] is in a two dimensional array, but the child if
 *    block condition assesses $_GET["password"]==$_GET["repassword"]. You should
 *    make this ($_GET["email"] ["password"]) into this ($_GET["email"] && 
 *    $["password"])
 */
if($_GET["firstname"] && $_GET["lastname"] && $_GET["email"] ["password"] && $_GET["repassword"])
{
    if($_GET["password"]==$_GET["repassword"])
    {
    $servername="";
    $username="";
    $password="";
    $conn=  mysql_connect($servername,$username,$password)or die(mysql_error());
    mysql_select_db("m",$conn);
    $firstname = mysql_real_escape_string( stripslashes( $_POST[ 'firstname' ] ) );
    $lastname  = mysql_real_escape_string( stripslashes( $_POST[ 'lastname' ] ) );
    $email     = mysql_real_escape_string( stripslashes( $_POST[ 'email' ] ) );
    $password  = mysql_real_escape_string( stripslashes( $_POST[ 'passowrd' ] ) );
    $address   = mysql_real_escape_string( stripslashes( $_POST[ 'address' ] ) );
    $month     = mysql_real_escape_string( stripslashes( $_POST[ 'month' ] ) );
    $date      = mysql_real_escape_string( stripslashes( $_POST[ 'date' ] ) );
    $year      = mysql_real_escape_string( stripslashes( $_POST[ 'year' ] ) );
    $sql="insert into datas (firstname,lastname,email,password,address,month,date,year)values('$_GET[firstname]','$_GET[lastname]','$_GET[email]','$_GET[password]','$_GET[address]','$_GET[month]','$_GET[date]','$_GET[year]')";
    $result=mysql_query($sql,$conn) or die(mysql_error());      
    print "<h1>you have registered sucessfully</h1>";
    print "<a href='index.php'>go to login page</a>";
    }
    else print "passwords doesnt match";
}
else print"invaild input data";

Moreover some points you should consider, although it's up to youif you'll take is:

  1. Use empty and isset when checking for required and empty POST or GET data
  2. Use either PDO or MySQLi for database accessing, since both are more secure than mysql

Edited by gon1387: additional

0

Thanks for all your time. the thing is, i am actually getting coding helps from reading books and the internet. and i just choose the path which seems more understanding for me to write.initially i wasnt taking security into account until i discovered this Daniweb. below is my html code pls.many thanks

<html>
  <head>
  <title>Index</title>
  </head>
  <body>
  <h2 align="center">User Registration Form</h4>
<FORM ACTION="register3.php" METHOD=get>
<h1>welcome to the registration pagep lease input the registration details to create an account here<br>
</h1>
<table border="2" align="center">
<tr>
<td width="12%">Name :</td><td><input name="firstname" type="text" size"20">  </input></td>
</tr>
<tr>
<td>Last Name :</td><td><input name="lastname" type="text" size"20"></input></td>
</tr>
<tr>
<td>email :</td><td><input name="email" type="text" size"20">  </input></td>
</tr>
<tr>
<td>password :</td><td><input name="password" type="password" size"20">  </input></td>
</tr>
<tr>
<td>retype password :</td><td><input name="repassword" type="password" size"20">  </input></td>
</tr>

<tr>
        <td valign="top" height="57">Address</td>
        <td height="58" colspan="2">
          <textarea name="address" cols="25" rows="4">  </textarea>        </td>
      </tr>

      <tr>
        <td valign="top"> Date of Birth</td>
        <td height="2" colspan="2">
          <select name=month>
            <option selected value=1>January
            <option value=2> February
            <option value=3>March
            <option value=4>April
            <option value=5>May
            <option value=6>June
            <option value=7>July
            <option value=8>August
            <option value=9>September
            <option value=10>October
            <option value=11>November
            <option value=12>December
      </select>
      <select name=date>
            <option selected value=1>01
            <option value=2>02
            <option value=3>03
            <option value=4>04
            <option value=5>05
            <option value=6>06
            <option value=7>07
            <option value=8>08
            <option value=9>09
            <option value=10>10
            <option value=11>11
            <option value=12>12
            <option value=13>13
            <option value=14>14
            <option value=15>15
            <option value=16>16
            <option value=17>17
            <option value=18>18
            <option value=19>19
            <option value=20>20
            <option value=21>21
            <option value=22>22
            <option value=23>23
            <option value=24>24
            <option value=25>25
            <option value=26>26
            <option value=27>27
            <option value=28>28
            <option value=29>29
            <option value=30>30
            <option value=31>31</option>
          </select>
          <select name=year>
            <option selected value=1>1930
            <option value=2>1931
            <option value=3>1932
            <option value=4>1933
            <option value=5>1934    
            <option value=6>1935</option>
          </select>
          Year

</td>
</tr>
        <tr>
        <td valign="top">Sex</td>
        <td height="2" width="42%"><input type="radio" name="sex" value="M">Male </td>
        <td height="2" width="21%"><input type="radio" name="sx" value="F">Female </td>
</tr>

<tr>
<!--for country -->
 <td valign="top">
  <label for="country">Country*</label>  </td>
<td valign="top" >
<select name="country">
<option value="2">American Samoa</option>
<option value="2">Andorra</option>
</select>
</tr>
<!-- end for country -->
        <td valign="top" height="57">Agreement</td>
        <td height="58" colspan="2"><textarea name="agreement" cols="25" rows="4"></textarea></td>
        <td height="2" width="11%"><input type="radio" name="sex" value="A">agree </td>
        <td height="2" width="14%"><input type="radio" name="sx" value="D">deny </td>
</tr>

</table>
<input  style="text-align:center" type="submit" value="register me!">
</input>
<input name="Reset" type="reset" value="reset!">
</input>

<!-- Grabbing IP of user -->
<input type="hidden" name="ip" id="ip" value="<?php echo $_SERVER['REMOTE_ADDR'];?>"  />
<!-- Grabbing current date -->
<input name="joindate" type="hidden" id="joindate" value="<?php echo date("F j, Y");?>" /> 
<!-- Required for inserting records into the table from registerform -->
<input type="hidden" name="MM_insert" value="registerform" /> 
 </FORM>
  </body>
  </html>
0

Hi again.
It's probably best to use the post method for your form so:

Change line 7 to
<form action="register3.php" method="post">

Place the 'name' values for month, date and year inside quotes
eg.
<select name="month">

Place the 'value' of your select tags inside quotes
eg.
<option selected value="1">

In your PHP page, because we chose the POST form method, we need to retrieve the values with

<?php
if (isset($_POST['firstname']{
    $firstname = $_POST['firstname'];
}
?>

You can then escape the data before you put it in the database:

<?php
// Your database connection code
$firstname = mysql_real_escape_string($firstname);
?>

As a sidenote, you may want to rename the string you use to store your database connection password ($password), as this same variable is being used by your form.

0

Hi Ziggy,
Many Thanks for your help but please could you kindly check my code i am finding it difficult to compare the two passwords using ==, i have change my form method to post.my syntaxes dont seem ok

<?php
 session_start();session_destroy();
 session_start();

if (isset($_POST['firstname']||
   (isset($_POST['lastname']||
   (isset($_POST['email']||
   (isset($_POST['password']||
   (isset($_POST['repassword']||
{   

   $firstname = $_POST['firstname'];
   $lastname = $_POST['lastname'];
   $email = $_POST['email']; 
   $password = $_POST['password'];
   $repassword = $_POST['repassword'];

    if($password==$repassword)
    {
    $servername="akamessan.ipagemysql.com";
    $username="members";
    $password="111222";

    $conn=  mysql_connect($servername,$username,$password)or die(mysql_error());
    mysql_select_db("memberdirectory",$conn);
    $firstname = mysql_real_escape_string( $firstname);
    $lastname  = mysql_real_escape_string( $lastname );
    $email     = mysql_real_escape_string( $email);
    $password  = mysql_real_escape_string( $passowrd);
    $address   = mysql_real_escape_string( $address);
    $month     = mysql_real_escape_string( $month);
    $date      = mysql_real_escape_string( $date);
    $year      = mysql_real_escape_string( $year);
    $sex       = mysql_real_escape_string( $sex );
    $country   = mysql_real_escape_string( $country);
    $agreement = mysql_real_escape_string( $agreement);

   $sql="insert into datas (firstname,lastname,email,password,address,month,date,year,sex,country)values('$firstname','$lastname','$email','$password','$address','$month','$date','$year','$sex','$country')";
   $result=mysql_query($sql,$conn) or die(mysql_error());       
   print "<h1>you have registered sucessfully</h1>";

    print "<a href='index.php'>go to login page</a>";
    }
    else print "passwords doesnt match";
}
else print"invaild input data";

?>
0

Hi,

Firstly, instead of using an OR condition in your first IF statement, use AND. This way all the fields need to be filled in before the form is processed. (The end of the IF statement was a bit malformed, which is corrected below).

if (isset($_POST['firstname'] &&
(isset($_POST['lastname'] &&
(isset($_POST['email'] &&
(isset($_POST['password'] &&
(isset($_POST['repassword'])
{ 

Secondly, you are setting $password to the value from the form, then you are changing this to your database connection password. This is why $password and $repassword don't match.
Change the name of your database password (line 22) to something like $dbpassword and then change line 24 to match that name.

Lastly (so far) you still have a typo on line 29
$password = mysql_real_escape_string( $passowrd);
should be
$password = mysql_real_escape_string( $password);

0

Hi Ziggy, i cant figure out what is wrong, i get "Internal server Error" message but with my old code it seems to connect to my database fine, so i think there is somthing i am not doing right. please could you help see to it

<?php
 session_start();session_destroy();
 session_start();

    if (isset($_POST['firstname'] &&
    (isset($_POST['lastname'] &&
    (isset($_POST['email'] &&
    (isset($_POST['password'] &&
    (isset($_POST['repassword'])

{   

   $firstname = $_POST['firstname'];
   $lastname = $_POST['lastname'];
   $email = $_POST['email']; 
   $password = $_POST['password'];
   $repassword = $_POST['repassword'];

    $servername="";
    $username="";
    $dbpassword="";

    $conn=  mysql_connect($servername,$username,$dbpassword)or die(mysql_error());
    mysql_select_db("memberdir",$conn);
    $firstname = mysql_real_escape_string( $firstname);
    $lastname  = mysql_real_escape_string( $lastname );
    $email     = mysql_real_escape_string( $email);
    $password  = mysql_real_escape_string( $password);
    $address   = mysql_real_escape_string( $address);
    $month     = mysql_real_escape_string( $month);
    $date      = mysql_real_escape_string( $date);
    $year      = mysql_real_escape_string( $year);
    $sex       = mysql_real_escape_string( $sex );
    $country   = mysql_real_escape_string( $country);
    $agreement = mysql_real_escape_string( $agreement);

    $sql="insert into datas (firstname,lastname,email,password,address,month,date,year,sex,country)values('$firstname','$lastname','$email','$password','$address','$month','$date','$year','$sex','$country')";
    $result=mysql_query($sql,$conn) or die(mysql_error());      
    print "<h1>you have registered sucessfully</h1>";

    print "<a href='index.php'>go to login page</a>";

}
else print"invaild input data";

?>
0

I gave you some bad code last time, I appologise. Not sure what happened.

Please change lines 5 to 11 with:

    if (isset($_POST['firstname']) &&
    isset($_POST['lastname']) &&
    isset($_POST['email']) &&
    isset($_POST['password']) &&
    isset($_POST['repassword']))
    {
0

Hi Ziggy once again, i know i am burdering you, please dont be angry, is just that this registrationform is the last stage of my web site. and i have reaaly learnt alot.Many thanks for you time, I finally got it to work and connect fine to the database after using your last code,But even when the fields are empty in the forms,it allow submission without entry the else stament(else print"invaild input data";). and it enters empty values and values of all dropdownlist in DB and says you are successfully registered. should i have used (!isset) below is my code please

<?php
 session_start();session_destroy();
 session_start();

     if (isset($_POST['firstname']) &&
    isset($_POST['lastname']) &&
    isset($_POST['email']) &&
    isset($_POST['password']) &&
    isset($_POST['repassword']))

{   

   $firstname = $_POST['firstname'];
   $lastname = $_POST['lastname'];
   $email = $_POST['email']; 
   $password = $_POST['password'];
   $repassword = $_POST['repassword'];

    if($password==$repassword)
    {
    $servername="";
    $username="";
    $dbpassword="";

    $conn=  mysql_connect($servername,$username,$dbpassword)or die(mysql_error());
    mysql_select_db("memberdir",$conn);
    $firstname = mysql_real_escape_string( $firstname);
    $lastname  = mysql_real_escape_string( $lastname );
    $email     = mysql_real_escape_string( $email);
    $password  = mysql_real_escape_string( $password);
    $address   = mysql_real_escape_string( $address);
    $month     = mysql_real_escape_string( $month);
    $date      = mysql_real_escape_string( $date);
    $year      = mysql_real_escape_string( $year);
    $sex       = mysql_real_escape_string( $sex );
    $country   = mysql_real_escape_string( $country);
    $agreement = mysql_real_escape_string( $agreement);
    $sql="insert into datas (firstname,lastname,email,password,address,month,date,year,sex,country)values('$firstname','$lastname','$email','$password','$address','$month','$date','$year','$sex','$country')";
    $result=mysql_query($sql,$conn) or die(mysql_error());      
    print "<h1>you have registered sucessfully</h1>";
    print "<a href='index.php'>go to login page</a>";
    }
    else print "passwords doesnt match";

}
else print"invaild input data";

?>
1

Hi again,
I'm not angry, but I can be a bit grumpy at times :) Sorry if I sounded abrupt earlier.
Im not entirely sure why you have included the session calls at the top of the page as the code you showed doesn't use sessions. I have removed this but you may need to replace it if you do actually use sessions.

<?php
if (isset($_POST['firstname']) && isset($_POST['lastname']) && isset($_POST['email']) && isset($_POST['password']) && isset($_POST['repassword'])){
    $firstname = $_POST['firstname'];
    $lastname = $_POST['lastname'];
    $email = $_POST['email'];
    $password = $_POST['password'];
    $repassword = $_POST['repassword'];
    if($password==$repassword){
        $servername="";
        $username="";
        $dbpassword="";
        $conn= mysql_connect($servername,$username,$dbpassword)or die(mysql_error());
        mysql_select_db("memberdir",$conn);
        $firstname = mysql_real_escape_string( $firstname);
        $lastname = mysql_real_escape_string( $lastname );
        $email = mysql_real_escape_string( $email);
        $password = mysql_real_escape_string( $password);
        $address = mysql_real_escape_string( $address);
        $month = mysql_real_escape_string( $month);
        $date = mysql_real_escape_string( $date);
        $year = mysql_real_escape_string( $year);
        $sex = mysql_real_escape_string( $sex );
        $country = mysql_real_escape_string( $country);
        $agreement = mysql_real_escape_string( $agreement);
        $sql="insert into datas (firstname,lastname,email,password,address,month,date,year,sex,country)values('$firstname','$lastname','$email','$password','$address','$month','$date','$year','$sex','$country')";
        $result=mysql_query($sql,$conn) or die(mysql_error());
        print "<h1>you have registered sucessfully</h1>";
        print "<a href='index.php'>go to login page</a>";
    }else{
        print "passwords dont match";
    }
}else{
    print"invaild input data";
}
?>

I have indented your code so you can see what each IF statement does a bit better. It also helps show what each ELSE statement does. You had mismatched the closing tags for the IF statements so they were getting mixed up.
The code should now run and display the message "invalid input data" if any fields are left blank, display the message "passwords dont match" if they don't match and only update the database if neither of the messages are displayed.

0

Many thanks Ziggy for your precious time but i am still having same problem, even when the form is empty, it goes ahead to insert empty fields in database. i have pasted again both my php code and my form code should you want to see to it.
thanks once again.

<?php
if (isset($_POST['firstname']) && isset($_POST['lastname']) && isset($_POST['email']) && isset($_POST['password']) && isset($_POST['repassword'])){
    $firstname = $_POST['firstname'];
    $lastname = $_POST['lastname'];
    $email = $_POST['email'];
    $password = $_POST['password'];
    $repassword = $_POST['repassword'];
    if($password==$repassword){
        $servername="";
        $username="";
        $dbpassword="";
        $conn= mysql_connect($servername,$username,$dbpassword)or die(mysql_error());
        mysql_select_db("memberdir",$conn);
        $firstname = mysql_real_escape_string( $firstname);
        $lastname = mysql_real_escape_string( $lastname );
        $email = mysql_real_escape_string( $email);
        $password = mysql_real_escape_string( $password);
        $address = mysql_real_escape_string( $address);
        $month = mysql_real_escape_string( $month);
        $date = mysql_real_escape_string( $date);
        $year = mysql_real_escape_string( $year);
        $sex = mysql_real_escape_string( $sex );
        $country = mysql_real_escape_string( $country);
        $agreement = mysql_real_escape_string( $agreement);
        $sql="insert into datas (firstname,lastname,email,password,address,month,date,year,sex,country)values('$firstname','$lastname','$email','$password','$address','$month','$date','$year','$sex','$country')";
        $result=mysql_query($sql,$conn) or die(mysql_error());
        print "<h1>you have registered sucessfully</h1>";
        print "<a href='index.php'>go to login page</a>";
    }else{
        print "passwords dont match";
    }
}else{
    print"invaild input data";
}
?>



<html>
  <head>
  <title>Index</title>
  </head>
  <body>
  <h4 align="center">User Registration Form</h4>
<form action="register3.php" method="post">
<h1>welcome to the registration pagep lease input the registration details to create an account here<br>
</h4>
<table border="2" align="center">
<tr>
<td width="12%">Name :</td><td><input name="firstname" type="text" size"20">  </input></td>
</tr>
<tr>
<td>Last Name :</td><td><input name="lastname" type="text" size"20"></input></td>
</tr>
<tr>
<td>email :</td><td><input name="email" type="text" size"20">  </input></td>
</tr>
<tr>
<td>password :</td><td><input name="password" type="password" size"20">  </input></td>
</tr>
<tr>
<td>retype password :</td><td><input name="repassword" type="password" size"20">  </input></td>
</tr>

<tr>
        <td valign="top" height="57">Address</td>
        <td height="58" colspan="2">
          <textarea name="address" cols="25" rows="4">  </textarea>        </td>
      </tr>

      <tr>
        <td valign="top"> Date of Birth</td>
        <td height="2" colspan="2">
          <select name="month">
            <option selected value="Jan">January
            <option selected value="Feb"> February
            <option selected value="Mar">March
            <option selected value="Apr">April
            <option selected value="May">May
            <option selected value="Jun">June
            <option selected value="Jul">July
            <option selected value="Aug">August
            <option selected value="Sep">September
            <option selected value="Oct">October
            <option selected value="Nov">November
            <option selected value="Dec">December
      </select>
      <select name="date">
            <option selected value="1">01
            <option selected value="2">02
            <option selected value="3">03
            <option selected value="4">04
            <option selected value="5">05
            <option selected value="6">06
            <option selected value="7">07
            <option selected value="8">08
            <option selected value="9">09
            <option selected value="10">10
            <option selected value="11">11
            <option selected value="12">12
            <option selected value="13">13
            <option selected value="14">14
            <option selected value="15">15
            <option selected value="16">16
            <option selected value="17">17
            <option selected value="18">18
            <option selected value="19">19
            <option selected value="20">20
            <option selected value="21">21
            <option selected value="22">22
            <option selected value="23">23
            <option selected value="24">24
            <option selected value="25">25
            <option selected value="26">26
            <option selected value="27">27
            <option selected value="28">28
            <option selected value="29">29
            <option selected value="30">30
            <option selected value="31">31</option>
          </select>
          <select name=year>
            <option selected value="1">1930
            <option selected value="2">1931
            <option selected value="3">1932
            <option selected value="4">1933
            <option selected value="5">1934    
            </select>Year


</td>
</tr>
        <tr>
        <td valign="top">Sex</td>
        <td height="2" width="42%"><input type="radio" name="sex" value="M">Male </td>
        <td height="2" width="21%"><input type="radio" name="sex" value="F">Female </td>
</tr>

<tr>
<!--for country -->
<td valign="top"> Country</td>
<td height="2" colspan="2">
<select name="country">
<option value="Afganistan">Afghanistan</option>
<option value="Albania">Albania</option>
<option value="Algeria">Algeria</option>
<option value="American Samoa">American Samoa</option>
<option value="Andorra">Andorra</option>
<option value="Angola">Angola</option>
<option value="Anguilla">Anguilla</option>
<option value="Antigua &amp; Barbuda">Antigua &amp; Barbuda</option>
<option value="Argentina">Argentina</option>
<option value="Armenia">Armenia</option>
<option value="Aruba">Aruba</option>
<option value="Australia">Australia</option>
<option value="Austria">Austria</option>
<option value="Azerbaijan">Azerbaijan</option>
<option value="Bahamas">Bahamas</option>
<option value="Bahrain">Bahrain</option>
<option value="Bangladesh">Bangladesh</option>
<option value="Barbados">Barbados</option>
<option value="Belarus">Belarus</option>
<option value="Belgium">Belgium</option>
<option value="Belize">Belize</option>
<option value="Benin">Benin</option>
<option value="Bermuda">Bermuda</option>
<option value="Bhutan">Bhutan</option>
<option value="Bolivia">Bolivia</option>
<option value="Bonaire">Bonaire</option>
<option value="Bosnia &amp; Herzegovina">Bosnia &amp; Herzegovina</option>
<option value="Botswana">Botswana</option>
<option value="Brazil">Brazil</option>
<option value="British Indian Ocean Ter">British Indian Ocean Ter</option>
<option value="Brunei">Brunei</option>
<option value="Bulgaria">Bulgaria</option>
<option value="Burkina Faso">Burkina Faso</option>
<option value="Burundi">Burundi</option>
<option value="Cambodia">Cambodia</option>
<option value="Cameroon">Cameroon</option>
<option value="Canada">Canada</option>
<option value="Canary Islands">Canary Islands</option>
<option value="Cape Verde">Cape Verde</option>
<option value="Cayman Islands">Cayman Islands</option>
<option value="Central African Republic">Central African Republic</option>
<option value="Chad">Chad</option>
<option value="Channel Islands">Channel Islands</option>
<option value="Chile">Chile</option>
<option value="China">China</option>
<option value="Christmas Island">Christmas Island</option>
<option value="Cocos Island">Cocos Island</option>
<option value="Colombia">Colombia</option>
<option value="Comoros">Comoros</option>
<option value="Congo">Congo</option>
<option value="Cook Islands">Cook Islands</option>
<option value="Costa Rica">Costa Rica</option>
<option value="Cote D'Ivoire">Cote D'Ivoire</option>
<option value="Croatia">Croatia</option>
<option value="Cuba">Cuba</option>
<option value="Curaco">Curacao</option>
<option value="Cyprus">Cyprus</option>
<option value="Czech Republic">Czech Republic</option>
<option value="Denmark">Denmark</option>
<option value="Djibouti">Djibouti</option>
<option value="Dominica">Dominica</option>
<option value="Dominican Republic">Dominican Republic</option>
<option value="East Timor">East Timor</option>
<option value="Ecuador">Ecuador</option>
<option value="Egypt">Egypt</option>
<option value="El Salvador">El Salvador</option>
<option value="Equatorial Guinea">Equatorial Guinea</option>
<option value="Eritrea">Eritrea</option>
<option value="Estonia">Estonia</option>
<option value="Ethiopia">Ethiopia</option>
<option value="Falkland Islands">Falkland Islands</option>
<option value="Faroe Islands">Faroe Islands</option>
<option value="Fiji">Fiji</option>
<option value="Finland">Finland</option>
<option value="France">France</option>
<option value="French Guiana">French Guiana</option>
<option value="French Polynesia">French Polynesia</option>
<option value="French Southern Ter">French Southern Ter</option>
<option value="Gabon">Gabon</option>
<option value="Gambia">Gambia</option>
<option value="Georgia">Georgia</option>
<option value="Germany">Germany</option>
<option value="Ghana">Ghana</option>
<option value="Gibraltar">Gibraltar</option>
<option value="Great Britain">Great Britain</option>
<option value="Greece">Greece</option>
<option value="Greenland">Greenland</option>
<option value="Grenada">Grenada</option>
<option value="Guadeloupe">Guadeloupe</option>
<option value="Guam">Guam</option>
<option value="Guatemala">Guatemala</option>
<option value="Guinea">Guinea</option>
<option value="Guyana">Guyana</option>
<option value="Haiti">Haiti</option>
<option value="Hawaii">Hawaii</option>
<option value="Honduras">Honduras</option>
<option value="Hong Kong">Hong Kong</option>
<option value="Hungary">Hungary</option>
<option value="Iceland">Iceland</option>
<option value="India">India</option>
<option value="Indonesia">Indonesia</option>
<option value="Iran">Iran</option>
<option value="Iraq">Iraq</option>
<option value="Ireland">Ireland</option>
<option value="Isle of Man">Isle of Man</option>
<option value="Israel">Israel</option>
<option value="Italy">Italy</option>
<option value="Jamaica">Jamaica</option>
<option value="Japan">Japan</option>
<option value="Jordan">Jordan</option>
<option value="Kazakhstan">Kazakhstan</option>
<option value="Kenya">Kenya</option>
<option value="Kiribati">Kiribati</option>
<option value="Korea North">Korea North</option>
<option value="Korea Sout">Korea South</option>
<option value="Kuwait">Kuwait</option>
<option value="Kyrgyzstan">Kyrgyzstan</option>
<option value="Laos">Laos</option>
<option value="Latvia">Latvia</option>
<option value="Lebanon">Lebanon</option>
<option value="Lesotho">Lesotho</option>
<option value="Liberia">Liberia</option>
<option value="Libya">Libya</option>
<option value="Liechtenstein">Liechtenstein</option>
<option value="Lithuania">Lithuania</option>
<option value="Luxembourg">Luxembourg</option>
<option value="Macau">Macau</option>
<option value="Macedonia">Macedonia</option>
<option value="Madagascar">Madagascar</option>
<option value="Malaysia">Malaysia</option>
<option value="Malawi">Malawi</option>
<option value="Maldives">Maldives</option>
<option value="Mali">Mali</option>
<option value="Malta">Malta</option>
<option value="Marshall Islands">Marshall Islands</option>
<option value="Martinique">Martinique</option>
<option value="Mauritania">Mauritania</option>
<option value="Mauritius">Mauritius</option>
<option value="Mayotte">Mayotte</option>
<option value="Mexico">Mexico</option>
<option value="Midway Islands">Midway Islands</option>
<option value="Moldova">Moldova</option>
<option value="Monaco">Monaco</option>
<option value="Mongolia">Mongolia</option>
<option value="Montserrat">Montserrat</option>
<option value="Morocco">Morocco</option>
<option value="Mozambique">Mozambique</option>
<option value="Myanmar">Myanmar</option>
<option value="Nambia">Nambia</option>
<option value="Nauru">Nauru</option>
<option value="Nepal">Nepal</option>
<option value="Netherland Antilles">Netherland Antilles</option>
<option value="Netherlands">Netherlands (Holland, Europe)</option>
<option value="Nevis">Nevis</option>
<option value="New Caledonia">New Caledonia</option>
<option value="New Zealand">New Zealand</option>
<option value="Nicaragua">Nicaragua</option>
<option value="Niger">Niger</option>
<option value="Nigeria">Nigeria</option>
<option value="Niue">Niue</option>
<option value="Norfolk Island">Norfolk Island</option>
<option value="Norway">Norway</option>
<option value="Oman">Oman</option>
<option value="Pakistan">Pakistan</option>
<option value="Palau Island">Palau Island</option>
<option value="Palestine">Palestine</option>
<option value="Panama">Panama</option>
<option value="Papua New Guinea">Papua New Guinea</option>
<option value="Paraguay">Paraguay</option>
<option value="Peru">Peru</option>
<option value="Phillipines">Philippines</option>
<option value="Pitcairn Island">Pitcairn Island</option>
<option value="Poland">Poland</option>
<option value="Portugal">Portugal</option>
<option value="Puerto Rico">Puerto Rico</option>
<option value="Qatar">Qatar</option>
<option value="Republic of Montenegro">Republic of Montenegro</option>
<option value="Republic of Serbia">Republic of Serbia</option>
<option value="Reunion">Reunion</option>
<option value="Romania">Romania</option>
<option value="Russia">Russia</option>
<option value="Rwanda">Rwanda</option>
<option value="St Barthelemy">St Barthelemy</option>
<option value="St Eustatius">St Eustatius</option>
<option value="St Helena">St Helena</option>
<option value="St Kitts-Nevis">St Kitts-Nevis</option>
<option value="St Lucia">St Lucia</option>
<option value="St Maarten">St Maarten</option>
<option value="St Pierre &amp; Miquelon">St Pierre &amp; Miquelon</option>
<option value="St Vincent &amp; Grenadines">St Vincent &amp; Grenadines</option>
<option value="Saipan">Saipan</option>
<option value="Samoa">Samoa</option>
<option value="Samoa American">Samoa American</option>
<option value="San Marino">San Marino</option>
<option value="Sao Tome & Principe">Sao Tome &amp; Principe</option>
<option value="Saudi Arabia">Saudi Arabia</option>
<option value="Senegal">Senegal</option>
<option value="Seychelles">Seychelles</option>
<option value="Sierra Leone">Sierra Leone</option>
<option value="Singapore">Singapore</option>
<option value="Slovakia">Slovakia</option>
<option value="Slovenia">Slovenia</option>
<option value="Solomon Islands">Solomon Islands</option>
<option value="Somalia">Somalia</option>
<option value="South Africa">South Africa</option>
<option value="Spain">Spain</option>
<option value="Sri Lanka">Sri Lanka</option>
<option value="Sudan">Sudan</option>
<option value="Suriname">Suriname</option>
<option value="Swaziland">Swaziland</option>
<option value="Sweden">Sweden</option>
<option value="Switzerland">Switzerland</option>
<option value="Syria">Syria</option>
<option value="Tahiti">Tahiti</option>
<option value="Taiwan">Taiwan</option>
<option value="Tajikistan">Tajikistan</option>
<option value="Tanzania">Tanzania</option>
<option value="Thailand">Thailand</option>
<option value="Togo">Togo</option>
<option value="Tokelau">Tokelau</option>
<option value="Tonga">Tonga</option>
<option value="Trinidad &amp; Tobago">Trinidad &amp; Tobago</option>
<option value="Tunisia">Tunisia</option>
<option value="Turkey">Turkey</option>
<option value="Turkmenistan">Turkmenistan</option>
<option value="Turks &amp; Caicos Is">Turks &amp; Caicos Is</option>
<option value="Tuvalu">Tuvalu</option>
<option value="Uganda">Uganda</option>
<option value="Ukraine">Ukraine</option>
<option value="United Arab Erimates">United Arab Emirates</option>
<option value="United Kingdom">United Kingdom</option>
<option value="United States of America">United States of America</option>
<option value="Uraguay">Uruguay</option>
<option value="Uzbekistan">Uzbekistan</option>
<option value="Vanuatu">Vanuatu</option>
<option value="Vatican City State">Vatican City State</option>
<option value="Venezuela">Venezuela</option>
<option value="Vietnam">Vietnam</option>
<option value="Virgin Islands (Brit)">Virgin Islands (Brit)</option>
<option value="Virgin Islands (USA)">Virgin Islands (USA)</option>
<option value="Wake Island">Wake Island</option>
<option value="Wallis &amp; Futana Is">Wallis &amp; Futana Is</option>
<option value="Yemen">Yemen</option>
<option value="Zaire">Zaire</option>
<option value="Zambia">Zambia</option>
<option value="Zimbabwe">Zimbabwe</option>
</select>

</tr>
<!-- end for country -->
        <td valign="top" height="57">Agreement</td>
        <td height="58" colspan="2"><textarea name="agreement" cols="25" rows="4"></textarea></td>
        <td height="2" width="11%"><input type="radio" name="agree" value="A">agree </td>
        <td height="2" width="14%"><input type="radio" name="deny" value="D">deny </td>
</tr>

</table>
<input  style="text-align:center" type="submit" value="register me!">
</input>
<input name="Reset" type="reset" value="reset!">
</input>

<!-- Grabbing IP of user -->
<input type="hidden" name="ip" id="ip" value="<?php echo $_SERVER['REMOTE_ADDR'];?>"  />
<!-- Grabbing current date -->
<input name="joindate" type="hidden" id="joindate" value="<?php echo date("F j, Y");?>" /> 
<!-- Required for inserting records into the table from registerform -->
<input type="hidden" name="MM_insert" value="registerform" /> 
 </FORM>
  </body>
  </html>
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.