MySQL help pleeeeeease!

Hello everyone, i really need some help as the website i have bought software wont reply to me. I bought a membership / profile software and have been using it for 2 years without a problem. People are able to register fine at www.famestreet.com/register.html but when they go to my ‘modify your profile’ page their details do not update and remain the same as what they put on the inital registration form. They are however, able to update their profile photos without a problem but the other fields such as name, age, country etc wont update

I do not receive any error messages and I can update their details ok through MyPHP control panel

Im at my wits end - I’ve really tried everything i can think of as im not very experienced.

This is my registration form code and my modification code underneath that


<form action=/cgi-bin/members/pm.cgi method=post>
<input type=hidden name=action value=register>
<table border=0 width="766">
<tr><td width="248">.<br><p></td><td></td></tr>
<tr>
      <td valign=middle width="248">
              <b>Login Name</b>

    </td>
    <td valign=top>
            <input type=text size=20 name=login>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              First Name

    </td>
    <td valign=top>
            <input type=text size=20 name=firstname>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              Last Name

    </td>
    <td valign=top>
            <input type=text size=20 name=lastname>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              <b>Email</b>

    </td>
    <td valign=top>
            <input type=text size=20 name=email>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              city

    </td>
    <td valign=top>
            <input type=text size=20 name=city>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              Country

    </td>
    <td valign=top>
            <select name=country>
    <option></option>
    <option>United States of America</option>
    <option>Canada</option>
    <option>Afghanistan</option>
    <option>Albania</option>
    <option>Algeria</option>
    <option>American Samoa</option>
    <option>Andorra</option>
    <option>Angola</option>
    <option>Anguilla</option>
    <option>Antarctica</option>
    <option>Antigua and Barbuda</option>
    <option>Argentina</option>
    <option>Armenia</option>
    <option>Australia</option>
    <option>Austria</option>
    <option>Azerbaijan</option>
    <option>Bahamas</option>
    <option>Bahrain</option>
    <option>Bangladesh</option>
    <option>Barbados</option>
    <option>Belarus</option>
    <option>Belgium</option>
    <option>Belize</option>
    <option>Bermuda</option>
    <option>Bhutan</option>
    <option>Bolivia</option>
    <option>Bosnia and Herzegovina</option>
    <option>Botswana</option>
    <option>Brazil</option>
    <option>Brunei Darussalam</option>
    <option>Bulgaria</option>
    <option>Burkina Faso</option>
    <option>Burundi</option>
    <option>Cambodia</option>
    <option>Cameroon</option>
    <option>Canada</option>
    <option>Central African Republic</option>
    <option>Chad</option>
    <option>Chile</option>
    <option>China</option>
    <option>Colombia</option>
    <option>Congo</option>
    <option>Cook Islands</option>
    <option>Costa Rica</option>
    <option>Croatia (Hrvatska)</option>
    <option>Cuba</option>
    <option>Cyprus</option>
    <option>Czech Republic</option>
    <option>Denmark</option>
    <option>Djibouti</option>
    <option>Dominica</option>
    <option>Dominican Republic</option>
    <option>East Timor</option>
    <option>Ecuador</option>
    <option>Egypt</option>
    <option>El Salvador</option>
    <option>Equatorial Guinea</option>
    <option>Eritrea</option>
    <option>Estonia</option>
    <option>Ethiopia</option>
    <option>Fiji</option>
    <option>Finland</option>
    <option>France</option>
    <option>French Guiana</option>
    <option>French Polynesia</option>
    <option>French Southern Territories</option>
    <option>Gabon</option>
    <option>Gambia</option>
    <option>Georgia</option>
    <option>Germany</option>
    <option>Ghana</option>
    <option>Gibraltar</option>
    <option>Greece</option>
    <option>Greenland</option>
    <option>Grenada</option>
    <option>Guadeloupe</option>
    <option>Guam</option>
    <option>Guatemala</option>
    <option>Guinea</option>
    <option>Guinea-Bissau</option>
    <option>Guyana</option>
    <option>Haiti</option>
    <option>Honduras</option>
    <option>Hong Kong</option>
    <option>Hungary</option>
    <option>Iceland</option>
    <option>India</option>
    <option>Indonesia</option>
    <option>Iran (Islamic Republic of)</option>
    <option>Iraq</option>
    <option>Ireland</option>
    <option>Israel</option>
    <option>Italy</option>
    <option>Jamaica</option>
    <option>Japan</option>
    <option>Jordan</option>
    <option>Kazakhstan</option>
    <option>Kenya</option>
    <option>Korea, Democratic Peoples Republic of</option>
    <option>Korea, Republic of</option>
    <option>Kuwait</option>
    <option>Kyrgyzstan</option>
    <option>Lao Peoples Democratic Republic</option>
    <option>Latvia</option>
    <option>Lebanon</option>
    <option>Lesotho</option>
    <option>Liberia</option>
    <option>Libyan Arab Jamahiriya</option>
    <option>Liechtenstein</option>
    <option>Lithuania</option>
    <option>Luxembourg</option>
    <option>Macau</option>
    <option>Macedonia</option>
    <option>Madagascar</option>
    <option>Malawi</option>
    <option>Malaysia</option>
    <option>Martinique</option>
    <option>Mauritania</option>
    <option>Mauritius</option>
    <option>Mexico</option>
    <option>Micronesia, Federated States Of</option>
    <option>Moldova, Republic of</option>
    <option>Monaco</option>
    <option>Mongolia</option>
    <option>Morocco</option>
    <option>Mozambique</option>
    <option>Namibia</option>
    <option>Nepal</option>
    <option>Netherlands</option>
    <option>Netherlands Antilles</option>
    <option>New Caledonia</option>
    <option>New Zealand</option>
    <option>Nicaragua</option>
    <option>Niger</option>
    <option>Nigeria</option>
    <option>Norway</option>
    <option>Oman</option>
    <option>Pakistan</option>
    <option>Panama</option>
    <option>Papua New Guinea</option>
    <option>Paraguay</option>
    <option>Peru</option>
    <option>Philippines</option>
    <option>Poland</option>
    <option>Portugal</option>
    <option>Puerto Rico</option>
    <option>Romania</option>
    <option>Russian Federation</option>
    <option>Rwanda</option>
    <option>Samoa</option>
    <option>Saudi Arabia</option>
    <option>Senegal</option>
    <option>Seychelles</option>
    <option>Sierra Leone</option>
    <option>Singapore</option>
    <option>Slovakia (Slovak Republic)</option>
    <option>Slovenia</option>
    <option>Somalia</option>
    <option>South Africa</option>
    <option>South Georgia</option>
    <option>Spain</option>
    <option>Sri Lanka</option>
    <option>Sudan</option>
    <option>Suriname</option>
    <option>Swaziland</option>
    <option>Sweden</option>
    <option>Switzerland</option>
    <option>Syrian Arab Republic</option>
    <option>Taiwan</option>
    <option>Tajikistan</option>
    <option>Tanzania, United Republic of</option>
    <option>Thailand</option>
    <option>Togo</option>
    <option>Tonga</option>
    <option>Trinidad and Tobago</option>
    <option>Tunisia</option>
    <option>Turkey</option>
    <option>Turkmenistan</option>
    <option>Uganda</option>
    <option>Ukraine</option>
    <option>United Arab Emirates</option>
    <option>United Kingdom</option>
    <option>United States of America</option>
    <option>Uruguay</option>
    <option>Uzbekistan</option>
    <option>Vatican City State (Holy See)</option>
    <option>Venezuela</option>
    <option>Viet Nam</option>
    <option>Virgin Islands (British)</option>
    <option>Virgin Islands (U.S.)</option>
    <option>Western Sahara</option>
    <option>Yemen</option>
    <option>Yugoslavia</option>
    <option>Zaire</option>
    <option>Zambia</option>
    <option>Zimbabwe</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              Gender

    </td>
    <td valign=top>
            <select name=gender>
    <option></option>
    <option>Male</option>
    <option>Female</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              Occupation

    </td>
    <td valign=top>
            <input type=text size=20 name=occupation>
    </td>
</tr> 

<tr>
      <td valign=top width="248">
              About you

    </td>
    <td valign=top>
            <textarea wrap=virtual cols=40 rows=3 name=hobbies></textarea>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              Homepage URL

    </td>
    <td valign=top>
            <input type=text size=20 name=homepage>
    </td>
</tr> 

<tr>
      <td valign=top width="248">
              Experience

    </td>
    <td valign=top>
            <textarea wrap=virtual cols=40 rows=3 name=any_experience></textarea>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              height

    </td>
    <td valign=top>
            <select name=your_height>
    <option></option>
    <option>under 4 foot</option>
    <option>4 foot 1 inch</option>
    <option>4 foot 2 inch</option>
    <option>4 foot 3 inch</option>
    <option>4 foot 4 inch</option>
    <option>4 foot 5 inch</option>
    <option>4 foot 6 inch</option>
    <option>4 foot 7 inch</option>
    <option>4 foot 8 inch</option>
    <option>4 foot 9 inch</option>
    <option>4 foot 10 inch</option>
    <option>4 foot 11 inch</option>
    <option>4 foot 12 inch</option>
    <option>5 foot</option>
    <option>5 foot 1 inch</option>
    <option>5 foot 2 inch</option>
    <option>5 foot 3 inch</option>
    <option>5 foot 4 inch</option>
    <option>5 foot 5 inch</option>
    <option>5 foot 6 inch</option>
    <option>5 foot 7 inch</option>
    <option>5 foot 8 inch</option>
    <option>5 foot 9 inch</option>
    <option>5 foot 10 inch</option>
    <option>5 foot 11 inch</option>
    <option>5 foot 12 inch</option>
    <option>6 foot</option>
    <option>6 foot 1 inch</option>
    <option>6 foot 2 inch</option>
    <option>6 foot 3 inch</option>
    <option>6 foot 4 inch</option>
    <option>6 foot 5 inch</option>
    <option>6 foot 6 inch</option>
    <option>6 foot 7 inch</option>
    <option>6 foot 8 inch</option>
    <option>6 foot 9 inch</option>
    <option>6 foot 10 inch</option>
    <option>6 foot 11 inch</option>
    <option>6 foot 12 inch</option>
    <option>7 foot</option>
    <option>over 7 foot</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              body type

    </td>
    <td valign=top>
            <select name=your_body>
    <option></option>
    <option>slim</option>
    <option>average</option>
    <option>athletic</option>
    <option>large</option>
    <option>extra large</option>
    <option>muscular</option>
    <option>other</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              hair colour

    </td>
    <td valign=top>
            <select name=your_hair>
    <option></option>
    <option>brown</option>
    <option>blonde</option>
    <option>black</option>
    <option>red / ginger</option>
    <option>white</option>
    <option>grey</option>
    <option>multi-coloured</option>
    <option>other</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              ethnicity

    </td>
    <td valign=top>
            <select name=your_ethnicity>
    <option></option>
    <option>white / caucasian</option>
    <option>african american / black</option>
    <option>asian</option>
    <option>mixed race</option>
    <option>oriental</option>
    <option>hispanic</option>
    <option>middle eastern</option>
    <option>native american / indian</option>
    <option>other</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              age

    </td>
    <td valign=top>
            <select name=fameage>
    <option></option>
    <option>under 18</option>
    <option>19 to 25</option>
    <option>26 to 35</option>
    <option>36 to 45</option>
    <option>46 to 55</option>
    <option>56 to 65</option>
    <option>over 65</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              Main Interest

    </td>
    <td valign=top>
            <select name=main_interest>
    <option></option>
    <option>Non professional</option>
    <option>Film extra</option>
    <option>Actor \\ Actress</option>
    <option>Model</option>
    <option>Singer</option>
    <option>Dancer</option>
    <option>Stage Performer</option>
    <option>Voice over artist</option>
    <option>Band</option>
    <option>Musician</option>
    <option>Entertainer</option>
    <option>Comedian</option>
    <option>Magician</option>
    <option>Recording studios / rehearsal rooms</option>
    <option>Stage school</option>
    <option>Photographer</option>
    <option>Video and showreels</option>
    <option>Training, coaching and tuition</option>
    <option>Film company</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle width="248">
              i agree

                to <a href="http://www.famestreet.com/terms.htm">T&amp;C</a></td>
    <td valign=top>
            <input type=checkbox name=iagree value=yes> 
    </td>
</tr> 

<tr><td width="248"></td><td><input type=submit name=submit value="  Register  ">
</form>

Modification code

<form action=pm.cgi method=post ENCTYPE=“multipart/form-data”>
<input type=hidden name=action value=modified>
<input type=hidden name=login value=“%%login%%”>
<input type=hidden name=ID value=“%%ID%%”>
<table border=0>
<tr><td><h2>Modify:

Sorry, I added code tags around the html, but it looks like I messed up you modification code. Please repost it.

No probs :slight_smile:


<form action=pm.cgi method=post ENCTYPE="multipart/form-data">
<input type=hidden name=action value=modified>
<input type=hidden name=login value="%%login%%">
<input type=hidden name=ID value="%%ID%%">
<table border=0>
<tr><td><h2>Modify/h2><br>Bold fields are required.<br><p></td><td></td></tr>
<tr>
      <td valign=middle>
              <b>Login Name</b>

    </td>
    <td valign=top>
            %%login%%
    </td>
</tr> 

<tr>
      <td valign=middle>
              First Name

    </td>
    <td valign=top>
            <input type=text size=20 name=firstname value="%%firstname%%">
    </td>
</tr> 

<tr>
      <td valign=middle>
              Last Name

    </td>
    <td valign=top>
            <input type=text size=20 name=lastname value="%%lastname%%">
    </td>
</tr> 

<tr>
      <td valign=middle>
              <b>Email</b>

    </td>
    <td valign=top>
            <input type=text size=20 name=email value="%%email%%">
    </td>
</tr> 

<tr>
      <td valign=middle>
              city

    </td>
    <td valign=top>
            <input type=text size=20 name=city value="%%city%%">
    </td>
</tr> 

<tr>
      <td valign=middle>
              Country

    </td>
    <td valign=top>
            <select name=country>
    <option>%%country%%</option>
    <option></option>
    <option>United States of America</option>
    <option>Canada</option>
    <option>Afghanistan</option>
    <option>Albania</option>
    <option>Algeria</option>
    <option>American Samoa</option>
    <option>Andorra</option>
    <option>Angola</option>
    <option>Anguilla</option>
    <option>Antarctica</option>
    <option>Antigua and Barbuda</option>
    <option>Argentina</option>
    <option>Armenia</option>
    <option>Australia</option>
    <option>Austria</option>
    <option>Azerbaijan</option>
    <option>Bahamas</option>
    <option>Bahrain</option>
    <option>Bangladesh</option>
    <option>Barbados</option>
    <option>Belarus</option>
    <option>Belgium</option>
    <option>Belize</option>
    <option>Bermuda</option>
    <option>Bhutan</option>
    <option>Bolivia</option>
    <option>Bosnia and Herzegovina</option>
    <option>Botswana</option>
    <option>Brazil</option>
    <option>Brunei Darussalam</option>
    <option>Bulgaria</option>
    <option>Burkina Faso</option>
    <option>Burundi</option>
    <option>Cambodia</option>
    <option>Cameroon</option>
    <option>Canada</option>
    <option>Central African Republic</option>
    <option>Chad</option>
    <option>Chile</option>
    <option>China</option>
    <option>Colombia</option>
    <option>Congo</option>
    <option>Cook Islands</option>
    <option>Costa Rica</option>
    <option>Croatia (Hrvatska)</option>
    <option>Cuba</option>
    <option>Cyprus</option>
    <option>Czech Republic</option>
    <option>Denmark</option>
    <option>Djibouti</option>
    <option>Dominica</option>
    <option>Dominican Republic</option>
    <option>East Timor</option>
    <option>Ecuador</option>
    <option>Egypt</option>
    <option>El Salvador</option>
    <option>Equatorial Guinea</option>
    <option>Eritrea</option>
    <option>Estonia</option>
    <option>Ethiopia</option>
    <option>Fiji</option>
    <option>Finland</option>
    <option>France</option>
    <option>French Guiana</option>
    <option>French Polynesia</option>
    <option>French Southern Territories</option>
    <option>Gabon</option>
    <option>Gambia</option>
    <option>Georgia</option>
    <option>Germany</option>
    <option>Ghana</option>
    <option>Gibraltar</option>
    <option>Greece</option>
    <option>Greenland</option>
    <option>Grenada</option>
    <option>Guadeloupe</option>
    <option>Guam</option>
    <option>Guatemala</option>
    <option>Guinea</option>
    <option>Guinea-Bissau</option>
    <option>Guyana</option>
    <option>Haiti</option>
    <option>Honduras</option>
    <option>Hong Kong</option>
    <option>Hungary</option>
    <option>Iceland</option>
    <option>India</option>
    <option>Indonesia</option>
    <option>Iran (Islamic Republic of)</option>
    <option>Iraq</option>
    <option>Ireland</option>
    <option>Israel</option>
    <option>Italy</option>
    <option>Jamaica</option>
    <option>Japan</option>
    <option>Jordan</option>
    <option>Kazakhstan</option>
    <option>Kenya</option>
    <option>Korea, Democratic Peoples Republic of</option>
    <option>Korea, Republic of</option>
    <option>Kuwait</option>
    <option>Kyrgyzstan</option>
    <option>Lao Peoples Democratic Republic</option>
    <option>Latvia</option>
    <option>Lebanon</option>
    <option>Lesotho</option>
    <option>Liberia</option>
    <option>Libyan Arab Jamahiriya</option>
    <option>Liechtenstein</option>
    <option>Lithuania</option>
    <option>Luxembourg</option>
    <option>Macau</option>
    <option>Macedonia</option>
    <option>Madagascar</option>
    <option>Malawi</option>
    <option>Malaysia</option>
    <option>Martinique</option>
    <option>Mauritania</option>
    <option>Mauritius</option>
    <option>Mexico</option>
    <option>Micronesia, Federated States Of</option>
    <option>Moldova, Republic of</option>
    <option>Monaco</option>
    <option>Mongolia</option>
    <option>Morocco</option>
    <option>Mozambique</option>
    <option>Namibia</option>
    <option>Nepal</option>
    <option>Netherlands</option>
    <option>Netherlands Antilles</option>
    <option>New Caledonia</option>
    <option>New Zealand</option>
    <option>Nicaragua</option>
    <option>Niger</option>
    <option>Nigeria</option>
    <option>Norway</option>
    <option>Oman</option>
    <option>Pakistan</option>
    <option>Panama</option>
    <option>Papua New Guinea</option>
    <option>Paraguay</option>
    <option>Peru</option>
    <option>Philippines</option>
    <option>Poland</option>
    <option>Portugal</option>
    <option>Puerto Rico</option>
    <option>Romania</option>
    <option>Russian Federation</option>
    <option>Rwanda</option>
    <option>Samoa</option>
    <option>Saudi Arabia</option>
    <option>Senegal</option>
    <option>Seychelles</option>
    <option>Sierra Leone</option>
    <option>Singapore</option>
    <option>Slovakia (Slovak Republic)</option>
    <option>Slovenia</option>
    <option>Somalia</option>
    <option>South Africa</option>
    <option>South Georgia</option>
    <option>Spain</option>
    <option>Sri Lanka</option>
    <option>Sudan</option>
    <option>Suriname</option>
    <option>Swaziland</option>
    <option>Sweden</option>
    <option>Switzerland</option>
    <option>Syrian Arab Republic</option>
    <option>Taiwan</option>
    <option>Tajikistan</option>
    <option>Tanzania, United Republic of</option>
    <option>Thailand</option>
    <option>Togo</option>
    <option>Tonga</option>
    <option>Trinidad and Tobago</option>
    <option>Tunisia</option>
    <option>Turkey</option>
    <option>Turkmenistan</option>
    <option>Uganda</option>
    <option>Ukraine</option>
    <option>United Arab Emirates</option>
    <option>United Kingdom</option>
    <option>United States of America</option>
    <option>Uruguay</option>
    <option>Uzbekistan</option>
    <option>Vatican City State (Holy See)</option>
    <option>Venezuela</option>
    <option>Viet Nam</option>
    <option>Virgin Islands (British)</option>
    <option>Virgin Islands (U.S.)</option>
    <option>Western Sahara</option>
    <option>Yemen</option>
    <option>Yugoslavia</option>
    <option>Zaire</option>
    <option>Zambia</option>
    <option>Zimbabwe</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle>
              Gender

    </td>
    <td valign=top>
            <select name=gender>
    <option>%%gender%%</option>
    <option></option>
    <option>Male</option>
    <option>Female</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle>
              Occupation

    </td>
    <td valign=top>
            <input type=text size=20 name=occupation value="%%occupation%%">
    </td>
</tr> 

<tr>
      <td valign=top>
              Hobbies

    </td>
    <td valign=top>
            <textarea wrap=virtual cols=40 rows=3 name=hobbies>%%hobbies%%</textarea>
    </td>
</tr> 

<tr>
      <td valign=middle>
              Homepage URL

    </td>
    <td valign=top>
            <input type=text size=20 name=homepage value="%%homepage%%">
    </td>
</tr> 

<tr>
      <td valign=top>
              Experience

    </td>
    <td valign=top>
            <textarea wrap=virtual cols=40 rows=3 name=any_experience>%%any_experience%%</textarea>
    </td>
</tr> 

<tr>
      <td valign=middle>
              height

    </td>
    <td valign=top>
            <select name=your_height>
    <option>%%your_height%%</option>
    <option></option>
    <option>under 4 foot</option>
    <option>4 foot 1 inch</option>
    <option>4 foot 2 inch</option>
    <option>4 foot 3 inch</option>
    <option>4 foot 4 inch</option>
    <option>4 foot 5 inch</option>
    <option>4 foot 6 inch</option>
    <option>4 foot 7 inch</option>
    <option>4 foot 8 inch</option>
    <option>4 foot 9 inch</option>
    <option>4 foot 10 inch</option>
    <option>4 foot 11 inch</option>
    <option>4 foot 12 inch</option>
    <option>5 foot</option>
    <option>5 foot 1 inch</option>
    <option>5 foot 2 inch</option>
    <option>5 foot 3 inch</option>
    <option>5 foot 4 inch</option>
    <option>5 foot 5 inch</option>
    <option>5 foot 6 inch</option>
    <option>5 foot 7 inch</option>
    <option>5 foot 8 inch</option>
    <option>5 foot 9 inch</option>
    <option>5 foot 10 inch</option>
    <option>5 foot 11 inch</option>
    <option>5 foot 12 inch</option>
    <option>6 foot</option>
    <option>6 foot 1 inch</option>
    <option>6 foot 2 inch</option>
    <option>6 foot 3 inch</option>
    <option>6 foot 4 inch</option>
    <option>6 foot 5 inch</option>
    <option>6 foot 6 inch</option>
    <option>6 foot 7 inch</option>
    <option>6 foot 8 inch</option>
    <option>6 foot 9 inch</option>
    <option>6 foot 10 inch</option>
    <option>6 foot 11 inch</option>
    <option>6 foot 12 inch</option>
    <option>7 foot</option>
    <option>over 7 foot</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle>
              body type

    </td>
    <td valign=top>
            <select name=your_body>
    <option>%%your_body%%</option>
    <option></option>
    <option>slim</option>
    <option>average</option>
    <option>athletic</option>
    <option>large</option>
    <option>extra large</option>
    <option>muscular</option>
    <option>other</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle>
              hair colour

    </td>
    <td valign=top>
            <select name=your_hair>
    <option>%%your_hair%%</option>
    <option></option>
    <option>brown</option>
    <option>blonde</option>
    <option>black</option>
    <option>red / ginger</option>
    <option>white</option>
    <option>grey</option>
    <option>multi-coloured</option>
    <option>other</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle>
              ethnicity

    </td>
    <td valign=top>
            <select name=your_ethnicity>
    <option>%%your_ethnicity%%</option>
    <option></option>
    <option>white / caucasian</option>
    <option>african american / black</option>
    <option>asian</option>
    <option>mixed race</option>
    <option>oriental</option>
    <option>hispanic</option>
    <option>middle eastern</option>
    <option>native american / indian</option>
    <option>other</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle>
              fameage

    </td>
    <td valign=top>
            <select name=fameage>
    <option>%%fameage%%</option>
    <option></option>
    <option>under 18</option>
    <option>19 to 25</option>
    <option>26 to 35</option>
    <option>36 to 45</option>
    <option>46 to 55</option>
    <option>56 to 65</option>
    <option>over 65</option>
</select>
    </td>
</tr> 

<tr>
      <td valign=middle>
              Main Interest

    </td>
    <td valign=top>
            <select name=main_interest>
    <option>%%main_interest%%</option>
    <option></option>
    <option>Non professional</option>
    <option>Film extra</option>
    <option>Actor \\ Actress</option>
    <option>Model</option>
    <option>Singer</option>
    <option>Dancer</option>
    <option>Stage Performer</option>
    <option>Voice over artist</option>
    <option>Band</option>
    <option>Musician</option>
    <option>Entertainer</option>
    <option>Comedian</option>
    <option>Magician</option>
    <option>Recording studios / rehearsal rooms</option>
    <option>Stage school</option>
    <option>Photographer</option>
    <option>Video and showreels</option>
    <option>Training, coaching and tuition</option>
    <option>Film company</option>
</select>
    </td>
</tr> 

<tr><td></td><td><input type=submit name=submit value="  Modify  ">
</form>
</td></table>

Both forms send their data to pm.cgi , so it’s the code from that script that is needed to find the reason.

Thanks guido but im not too clever with this stuff. Where would i find that script so that i can post it here please. I use an installed software called Profile Premium Manager by Interlogy. I have access to all the pages but would not know where to look for the script that you suggest. Please help, thanks

I’ve never worked with cgi, but if it was pm.php then there would be a file called pm.php in the same directory as where you got the html form code from you posted.

its not PHP unfortunately. The registration form ( www.famestreet.com/register.html ) works fine and puts the users details on their profile without a problem. The problem is when they try to update those details at a later date

Looks like the pm.cgi could possibly be http://stein.cshl.org/WWW/CGI/ but I can’t say for sure, if it is then the server-side language is Perl. Can’t see any metion of updating there so you might to update have to generate the form with the fields being populated from the database, edit the fields and then save but depending on how everything is set up, it might end up creating a new record instead

The pm.cgi script should be located here: http://www.famestreet.com/cgi-bin/members/pm.cgi

The easiest way to view a copy of the code is to fire up your favorite FTP client, log into your site, and navigate to the cgi-bin. At this point you should be able to find the code and then ask someone with Perl knowledge if they can take a look for you.