SitePoint Sponsor

User Tag List

Results 1 to 9 of 9

Threaded View

  1. #1
    SitePoint Member
    Join Date
    Oct 2013
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Smile 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

    Code:
    <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:
    Last edited by DaveMaxwell; Oct 2, 2013 at 12:15. Reason: added code tags


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •