473,395 Members | 1,488 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

MySQL Database updating problem. Please help

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

Expand|Select|Wrap|Line Numbers
  1. <form action=/cgi-bin/members/pm.cgi method=post>
  2. <input type=hidden name=action value=register>
  3. <table border=0 width="766">
  4. <tr><td width="248">.<br><p></td><td></td></tr>
  5. <tr>
  6.       <td valign=middle width="248">
  7.               <b>Login Name</b>
  8.  
  9.     </td>
  10.     <td valign=top>
  11.             <input type=text size=20 name=login>
  12.     </td>
  13. </tr> 
  14.  
  15. <tr>
  16.       <td valign=middle width="248">
  17.               First Name
  18.  
  19.     </td>
  20.     <td valign=top>
  21.             <input type=text size=20 name=firstname>
  22.     </td>
  23. </tr> 
  24.  
  25. <tr>
  26.       <td valign=middle width="248">
  27.               Last Name
  28.  
  29.     </td>
  30.     <td valign=top>
  31.             <input type=text size=20 name=lastname>
  32.     </td>
  33. </tr> 
  34.  
  35. <tr>
  36.       <td valign=middle width="248">
  37.               <b>Email</b>
  38.  
  39.     </td>
  40.     <td valign=top>
  41.             <input type=text size=20 name=email>
  42.     </td>
  43. </tr> 
  44.  
  45. <tr>
  46.       <td valign=middle width="248">
  47.               city
  48.  
  49.     </td>
  50.     <td valign=top>
  51.             <input type=text size=20 name=city>
  52.     </td>
  53. </tr> 
  54.  
  55. <tr>
  56.       <td valign=middle width="248">
  57.               Country
  58.  
  59.     </td>
  60.     <td valign=top>
  61.             <select name=country>
  62.     <option></option>
  63.     <option>United States of America</option>
  64.     <option>Canada</option>
  65.     <option>Afghanistan</option>
  66.     <option>Albania</option>
  67.     <option>Algeria</option>
  68.     <option>American Samoa</option>
  69.     <option>Andorra</option>
  70.     <option>Angola</option>
  71.     <option>Anguilla</option>
  72.     <option>Antarctica</option>
  73.     <option>Antigua and Barbuda</option>
  74.     <option>Argentina</option>
  75.     <option>Armenia</option>
  76.     <option>Australia</option>
  77.     <option>Austria</option>
  78.     <option>Azerbaijan</option>
  79.     <option>Bahamas</option>
  80.     <option>Bahrain</option>
  81.     <option>Bangladesh</option>
  82.     <option>Barbados</option>
  83.     <option>Belarus</option>
  84.     <option>Belgium</option>
  85.     <option>Belize</option>
  86.     <option>Bermuda</option>
  87.     <option>Bhutan</option>
  88.     <option>Bolivia</option>
  89.     <option>Bosnia and Herzegovina</option>
  90.     <option>Botswana</option>
  91.     <option>Brazil</option>
  92.     <option>Brunei Darussalam</option>
  93.     <option>Bulgaria</option>
  94.     <option>Burkina Faso</option>
  95.     <option>Burundi</option>
  96.     <option>Cambodia</option>
  97.     <option>Cameroon</option>
  98.     <option>Canada</option>
  99.     <option>Central African Republic</option>
  100.     <option>Chad</option>
  101.     <option>Chile</option>
  102.     <option>China</option>
  103.     <option>Colombia</option>
  104.     <option>Congo</option>
  105.     <option>Cook Islands</option>
  106.     <option>Costa Rica</option>
  107.     <option>Croatia (Hrvatska)</option>
  108.     <option>Cuba</option>
  109.     <option>Cyprus</option>
  110.     <option>Czech Republic</option>
  111.     <option>Denmark</option>
  112.     <option>Djibouti</option>
  113.     <option>Dominica</option>
  114.     <option>Dominican Republic</option>
  115.     <option>East Timor</option>
  116.     <option>Ecuador</option>
  117.     <option>Egypt</option>
  118.     <option>El Salvador</option>
  119.     <option>Equatorial Guinea</option>
  120.     <option>Eritrea</option>
  121.     <option>Estonia</option>
  122.     <option>Ethiopia</option>
  123.     <option>Fiji</option>
  124.     <option>Finland</option>
  125.     <option>France</option>
  126.     <option>French Guiana</option>
  127.     <option>French Polynesia</option>
  128.     <option>French Southern Territories</option>
  129.     <option>Gabon</option>
  130.     <option>Gambia</option>
  131.     <option>Georgia</option>
  132.     <option>Germany</option>
  133.     <option>Ghana</option>
  134.     <option>Gibraltar</option>
  135.     <option>Greece</option>
  136.     <option>Greenland</option>
  137.     <option>Grenada</option>
  138.     <option>Guadeloupe</option>
  139.     <option>Guam</option>
  140.     <option>Guatemala</option>
  141.     <option>Guinea</option>
  142.     <option>Guinea-Bissau</option>
  143.     <option>Guyana</option>
  144.     <option>Haiti</option>
  145.     <option>Honduras</option>
  146.     <option>Hong Kong</option>
  147.     <option>Hungary</option>
  148.     <option>Iceland</option>
  149.     <option>India</option>
  150.     <option>Indonesia</option>
  151.     <option>Iran (Islamic Republic of)</option>
  152.     <option>Iraq</option>
  153.     <option>Ireland</option>
  154.     <option>Israel</option>
  155.     <option>Italy</option>
  156.     <option>Jamaica</option>
  157.     <option>Japan</option>
  158.     <option>Jordan</option>
  159.     <option>Kazakhstan</option>
  160.     <option>Kenya</option>
  161.     <option>Korea, Democratic Peoples Republic of</option>
  162.     <option>Korea, Republic of</option>
  163.     <option>Kuwait</option>
  164.     <option>Kyrgyzstan</option>
  165.     <option>Lao Peoples Democratic Republic</option>
  166.     <option>Latvia</option>
  167.     <option>Lebanon</option>
  168.     <option>Lesotho</option>
  169.     <option>Liberia</option>
  170.     <option>Libyan Arab Jamahiriya</option>
  171.     <option>Liechtenstein</option>
  172.     <option>Lithuania</option>
  173.     <option>Luxembourg</option>
  174.     <option>Macau</option>
  175.     <option>Macedonia</option>
  176.     <option>Madagascar</option>
  177.     <option>Malawi</option>
  178.     <option>Malaysia</option>
  179.     <option>Martinique</option>
  180.     <option>Mauritania</option>
  181.     <option>Mauritius</option>
  182.     <option>Mexico</option>
  183.     <option>Micronesia, Federated States Of</option>
  184.     <option>Moldova, Republic of</option>
  185.     <option>Monaco</option>
  186.     <option>Mongolia</option>
  187.     <option>Morocco</option>
  188.     <option>Mozambique</option>
  189.     <option>Namibia</option>
  190.     <option>Nepal</option>
  191.     <option>Netherlands</option>
  192.     <option>Netherlands Antilles</option>
  193.     <option>New Caledonia</option>
  194.     <option>New Zealand</option>
  195.     <option>Nicaragua</option>
  196.     <option>Niger</option>
  197.     <option>Nigeria</option>
  198.     <option>Norway</option>
  199.     <option>Oman</option>
  200.     <option>Pakistan</option>
  201.     <option>Panama</option>
  202.     <option>Papua New Guinea</option>
  203.     <option>Paraguay</option>
  204.     <option>Peru</option>
  205.     <option>Philippines</option>
  206.     <option>Poland</option>
  207.     <option>Portugal</option>
  208.     <option>Puerto Rico</option>
  209.     <option>Romania</option>
  210.     <option>Russian Federation</option>
  211.     <option>Rwanda</option>
  212.     <option>Samoa</option>
  213.     <option>Saudi Arabia</option>
  214.     <option>Senegal</option>
  215.     <option>Seychelles</option>
  216.     <option>Sierra Leone</option>
  217.     <option>Singapore</option>
  218.     <option>Slovakia (Slovak Republic)</option>
  219.     <option>Slovenia</option>
  220.     <option>Somalia</option>
  221.     <option>South Africa</option>
  222.     <option>South Georgia</option>
  223.     <option>Spain</option>
  224.     <option>Sri Lanka</option>
  225.     <option>Sudan</option>
  226.     <option>Suriname</option>
  227.     <option>Swaziland</option>
  228.     <option>Sweden</option>
  229.     <option>Switzerland</option>
  230.     <option>Syrian Arab Republic</option>
  231.     <option>Taiwan</option>
  232.     <option>Tajikistan</option>
  233.     <option>Tanzania, United Republic of</option>
  234.     <option>Thailand</option>
  235.     <option>Togo</option>
  236.     <option>Tonga</option>
  237.     <option>Trinidad and Tobago</option>
  238.     <option>Tunisia</option>
  239.     <option>Turkey</option>
  240.     <option>Turkmenistan</option>
  241.     <option>Uganda</option>
  242.     <option>Ukraine</option>
  243.     <option>United Arab Emirates</option>
  244.     <option>United Kingdom</option>
  245.     <option>United States of America</option>
  246.     <option>Uruguay</option>
  247.     <option>Uzbekistan</option>
  248.     <option>Vatican City State (Holy See)</option>
  249.     <option>Venezuela</option>
  250.     <option>Viet Nam</option>
  251.     <option>Virgin Islands (British)</option>
  252.     <option>Virgin Islands (U.S.)</option>
  253.     <option>Western Sahara</option>
  254.     <option>Yemen</option>
  255.     <option>Yugoslavia</option>
  256.     <option>Zaire</option>
  257.     <option>Zambia</option>
  258.     <option>Zimbabwe</option>
  259. </select>
  260.     </td>
  261. </tr> 
  262.  
  263. <tr>
  264.       <td valign=middle width="248">
  265.               Gender
  266.  
  267.     </td>
  268.     <td valign=top>
  269.             <select name=gender>
  270.     <option></option>
  271.     <option>Male</option>
  272.     <option>Female</option>
  273. </select>
  274.     </td>
  275. </tr> 
  276.  
  277. <tr>
  278.       <td valign=middle width="248">
  279.               Occupation
  280.  
  281.     </td>
  282.     <td valign=top>
  283.             <input type=text size=20 name=occupation>
  284.     </td>
  285. </tr> 
  286.  
  287. <tr>
  288.       <td valign=top width="248">
  289.               About you
  290.  
  291.     </td>
  292.     <td valign=top>
  293.             <textarea wrap=virtual cols=40 rows=3 name=hobbies></textarea>
  294.     </td>
  295. </tr> 
  296.  
  297. <tr>
  298.       <td valign=middle width="248">
  299.               Homepage URL
  300.  
  301.     </td>
  302.     <td valign=top>
  303.             <input type=text size=20 name=homepage>
  304.     </td>
  305. </tr> 
  306.  
  307. <tr>
  308.       <td valign=top width="248">
  309.               Experience
  310.  
  311.     </td>
  312.     <td valign=top>
  313.             <textarea wrap=virtual cols=40 rows=3 name=any_experience></textarea>
  314.     </td>
  315. </tr> 
  316.  
  317. <tr>
  318.       <td valign=middle width="248">
  319.               height
  320.  
  321.     </td>
  322.     <td valign=top>
  323.             <select name=your_height>
  324.     <option></option>
  325.     <option>under 4 foot</option>
  326.     <option>4 foot 1 inch</option>
  327.     <option>4 foot 2 inch</option>
  328.     <option>4 foot 3 inch</option>
  329.     <option>4 foot 4 inch</option>
  330.     <option>4 foot 5 inch</option>
  331.     <option>4 foot 6 inch</option>
  332.     <option>4 foot 7 inch</option>
  333.     <option>4 foot 8 inch</option>
  334.     <option>4 foot 9 inch</option>
  335.     <option>4 foot 10 inch</option>
  336.     <option>4 foot 11 inch</option>
  337.     <option>4 foot 12 inch</option>
  338.     <option>5 foot</option>
  339.     <option>5 foot 1 inch</option>
  340.     <option>5 foot 2 inch</option>
  341.     <option>5 foot 3 inch</option>
  342.     <option>5 foot 4 inch</option>
  343.     <option>5 foot 5 inch</option>
  344.     <option>5 foot 6 inch</option>
  345.     <option>5 foot 7 inch</option>
  346.     <option>5 foot 8 inch</option>
  347.     <option>5 foot 9 inch</option>
  348.     <option>5 foot 10 inch</option>
  349.     <option>5 foot 11 inch</option>
  350.     <option>5 foot 12 inch</option>
  351.     <option>6 foot</option>
  352.     <option>6 foot 1 inch</option>
  353.     <option>6 foot 2 inch</option>
  354.     <option>6 foot 3 inch</option>
  355.     <option>6 foot 4 inch</option>
  356.     <option>6 foot 5 inch</option>
  357.     <option>6 foot 6 inch</option>
  358.     <option>6 foot 7 inch</option>
  359.     <option>6 foot 8 inch</option>
  360.     <option>6 foot 9 inch</option>
  361.     <option>6 foot 10 inch</option>
  362.     <option>6 foot 11 inch</option>
  363.     <option>6 foot 12 inch</option>
  364.     <option>7 foot</option>
  365.     <option>over 7 foot</option>
  366. </select>
  367.     </td>
  368. </tr> 
  369.  
  370. <tr>
  371.       <td valign=middle width="248">
  372.               body type
  373.  
  374.     </td>
  375.     <td valign=top>
  376.             <select name=your_body>
  377.     <option></option>
  378.     <option>slim</option>
  379.     <option>average</option>
  380.     <option>athletic</option>
  381.     <option>large</option>
  382.     <option>extra large</option>
  383.     <option>muscular</option>
  384.     <option>other</option>
  385. </select>
  386.     </td>
  387. </tr> 
  388.  
  389. <tr>
  390.       <td valign=middle width="248">
  391.               hair colour
  392.  
  393.     </td>
  394.     <td valign=top>
  395.             <select name=your_hair>
  396.     <option></option>
  397.     <option>brown</option>
  398.     <option>blonde</option>
  399.     <option>black</option>
  400.     <option>red / ginger</option>
  401.     <option>white</option>
  402.     <option>grey</option>
  403.     <option>multi-coloured</option>
  404.     <option>other</option>
  405. </select>
  406.     </td>
  407. </tr> 
  408.  
  409. <tr>
  410.       <td valign=middle width="248">
  411.               ethnicity
  412.  
  413.     </td>
  414.     <td valign=top>
  415.             <select name=your_ethnicity>
  416.     <option></option>
  417.     <option>white / caucasian</option>
  418.     <option>african american / black</option>
  419.     <option>asian</option>
  420.     <option>mixed race</option>
  421.     <option>oriental</option>
  422.     <option>hispanic</option>
  423.     <option>middle eastern</option>
  424.     <option>native american / indian</option>
  425.     <option>other</option>
  426. </select>
  427.     </td>
  428. </tr> 
  429.  
  430. <tr>
  431.       <td valign=middle width="248">
  432.               age
  433.  
  434.     </td>
  435.     <td valign=top>
  436.             <select name=fameage>
  437.     <option></option>
  438.     <option>under 18</option>
  439.     <option>19 to 25</option>
  440.     <option>26 to 35</option>
  441.     <option>36 to 45</option>
  442.     <option>46 to 55</option>
  443.     <option>56 to 65</option>
  444.     <option>over 65</option>
  445. </select>
  446.     </td>
  447. </tr> 
  448.  
  449. <tr>
  450.       <td valign=middle width="248">
  451.               Main Interest
  452.  
  453.     </td>
  454.     <td valign=top>
  455.             <select name=main_interest>
  456.     <option></option>
  457.     <option>Non professional</option>
  458.     <option>Film extra</option>
  459.     <option>Actor \ Actress</option>
  460.     <option>Model</option>
  461.     <option>Singer</option>
  462.     <option>Dancer</option>
  463.     <option>Stage Performer</option>
  464.     <option>Voice over artist</option>
  465.     <option>Band</option>
  466.     <option>Musician</option>
  467.     <option>Entertainer</option>
  468.     <option>Comedian</option>
  469.     <option>Magician</option>
  470.     <option>Recording studios / rehearsal rooms</option>
  471.     <option>Stage school</option>
  472.     <option>Photographer</option>
  473.     <option>Video and showreels</option>
  474.     <option>Training, coaching and tuition</option>
  475.     <option>Film company</option>
  476. </select>
  477.     </td>
  478. </tr> 
  479.  
  480. <tr>
  481.       <td valign=middle width="248">
  482.               i agree
  483.  
  484.                 to <a href="http://www.famestreet.com/terms.htm">T&amp;C</a></td>
  485.     <td valign=top>
  486.             <input type=checkbox name=iagree value=yes> 
  487.     </td>
  488. </tr> 
  489.  
  490. <tr><td width="248"></td><td><input type=submit name=submit value="  Register  ">
  491. </form>
  492.  
  493.  
  494.  
  495.  
  496.  
  497. Modification code
  498.  
  499.  
  500.  
  501. <form action=pm.cgi method=post ENCTYPE="multipart/form-data">
  502. <input type=hidden name=action value=modified>
  503. <input type=hidden name=login value="%%login%%">
  504. <input type=hidden name=ID value="%%ID%%">
  505. <table border=0>
  506. <tr><td><h2>Modify:</h2><br>Bold fields are required.<br><p></td><td></td></tr>
  507. <tr>
  508.       <td valign=middle>
  509.               <b>Login Name</b>
  510.  
  511.     </td>
  512.     <td valign=top>
  513.             %%login%%
  514.     </td>
  515. </tr> 
  516.  
  517. <tr>
  518.       <td valign=middle>
  519.               First Name
  520.  
  521.     </td>
  522.     <td valign=top>
  523.             <input type=text size=20 name=firstname value="%%firstname%%">
  524.     </td>
  525. </tr> 
  526.  
  527. <tr>
  528.       <td valign=middle>
  529.               Last Name
  530.  
  531.     </td>
  532.     <td valign=top>
  533.             <input type=text size=20 name=lastname value="%%lastname%%">
  534.     </td>
  535. </tr> 
  536.  
  537. <tr>
  538.       <td valign=middle>
  539.               <b>Email</b>
  540.  
  541.     </td>
  542.     <td valign=top>
  543.             <input type=text size=20 name=email value="%%email%%">
  544.     </td>
  545. </tr> 
  546.  
  547. <tr>
  548.       <td valign=middle>
  549.               city
  550.  
  551.     </td>
  552.     <td valign=top>
  553.             <input type=text size=20 name=city value="%%city%%">
  554.     </td>
  555. </tr> 
  556.  
  557. <tr>
  558.       <td valign=middle>
  559.               Country
  560.  
  561.     </td>
  562.     <td valign=top>
  563.             <select name=country>
  564.     <option>%%country%%</option>
  565.     <option></option>
  566.     <option>United States of America</option>
  567.     <option>Canada</option>
  568.     <option>Afghanistan</option>
  569.     <option>Albania</option>
  570.     <option>Algeria</option>
  571.     <option>American Samoa</option>
  572.     <option>Andorra</option>
  573.     <option>Angola</option>
  574.     <option>Anguilla</option>
  575.     <option>Antarctica</option>
  576.     <option>Antigua and Barbuda</option>
  577.     <option>Argentina</option>
  578.     <option>Armenia</option>
  579.     <option>Australia</option>
  580.     <option>Austria</option>
  581.     <option>Azerbaijan</option>
  582.     <option>Bahamas</option>
  583.     <option>Bahrain</option>
  584.     <option>Bangladesh</option>
  585.     <option>Barbados</option>
  586.     <option>Belarus</option>
  587.     <option>Belgium</option>
  588.     <option>Belize</option>
  589.     <option>Bermuda</option>
  590.     <option>Bhutan</option>
  591.     <option>Bolivia</option>
  592.     <option>Bosnia and Herzegovina</option>
  593.     <option>Botswana</option>
  594.     <option>Brazil</option>
  595.     <option>Brunei Darussalam</option>
  596.     <option>Bulgaria</option>
  597.     <option>Burkina Faso</option>
  598.     <option>Burundi</option>
  599.     <option>Cambodia</option>
  600.     <option>Cameroon</option>
  601.     <option>Canada</option>
  602.     <option>Central African Republic</option>
  603.     <option>Chad</option>
  604.     <option>Chile</option>
  605.     <option>China</option>
  606.     <option>Colombia</option>
  607.     <option>Congo</option>
  608.     <option>Cook Islands</option>
  609.     <option>Costa Rica</option>
  610.     <option>Croatia (Hrvatska)</option>
  611.     <option>Cuba</option>
  612.     <option>Cyprus</option>
  613.     <option>Czech Republic</option>
  614.     <option>Denmark</option>
  615.     <option>Djibouti</option>
  616.     <option>Dominica</option>
  617.     <option>Dominican Republic</option>
  618.     <option>East Timor</option>
  619.     <option>Ecuador</option>
  620.     <option>Egypt</option>
  621.     <option>El Salvador</option>
  622.     <option>Equatorial Guinea</option>
  623.     <option>Eritrea</option>
  624.     <option>Estonia</option>
  625.     <option>Ethiopia</option>
  626.     <option>Fiji</option>
  627.     <option>Finland</option>
  628.     <option>France</option>
  629.     <option>French Guiana</option>
  630.     <option>French Polynesia</option>
  631.     <option>French Southern Territories</option>
  632.     <option>Gabon</option>
  633.     <option>Gambia</option>
  634.     <option>Georgia</option>
  635.     <option>Germany</option>
  636.     <option>Ghana</option>
  637.     <option>Gibraltar</option>
  638.     <option>Greece</option>
  639.     <option>Greenland</option>
  640.     <option>Grenada</option>
  641.     <option>Guadeloupe</option>
  642.     <option>Guam</option>
  643.     <option>Guatemala</option>
  644.     <option>Guinea</option>
  645.     <option>Guinea-Bissau</option>
  646.     <option>Guyana</option>
  647.     <option>Haiti</option>
  648.     <option>Honduras</option>
  649.     <option>Hong Kong</option>
  650.     <option>Hungary</option>
  651.     <option>Iceland</option>
  652.     <option>India</option>
  653.     <option>Indonesia</option>
  654.     <option>Iran (Islamic Republic of)</option>
  655.     <option>Iraq</option>
  656.     <option>Ireland</option>
  657.     <option>Israel</option>
  658.     <option>Italy</option>
  659.     <option>Jamaica</option>
  660.     <option>Japan</option>
  661.     <option>Jordan</option>
  662.     <option>Kazakhstan</option>
  663.     <option>Kenya</option>
  664.     <option>Korea, Democratic Peoples Republic of</option>
  665.     <option>Korea, Republic of</option>
  666.     <option>Kuwait</option>
  667.     <option>Kyrgyzstan</option>
  668.     <option>Lao Peoples Democratic Republic</option>
  669.     <option>Latvia</option>
  670.     <option>Lebanon</option>
  671.     <option>Lesotho</option>
  672.     <option>Liberia</option>
  673.     <option>Libyan Arab Jamahiriya</option>
  674.     <option>Liechtenstein</option>
  675.     <option>Lithuania</option>
  676.     <option>Luxembourg</option>
  677.     <option>Macau</option>
  678.     <option>Macedonia</option>
  679.     <option>Madagascar</option>
  680.     <option>Malawi</option>
  681.     <option>Malaysia</option>
  682.     <option>Martinique</option>
  683.     <option>Mauritania</option>
  684.     <option>Mauritius</option>
  685.     <option>Mexico</option>
  686.     <option>Micronesia, Federated States Of</option>
  687.     <option>Moldova, Republic of</option>
  688.     <option>Monaco</option>
  689.     <option>Mongolia</option>
  690.     <option>Morocco</option>
  691.     <option>Mozambique</option>
  692.     <option>Namibia</option>
  693.     <option>Nepal</option>
  694.     <option>Netherlands</option>
  695.     <option>Netherlands Antilles</option>
  696.     <option>New Caledonia</option>
  697.     <option>New Zealand</option>
  698.     <option>Nicaragua</option>
  699.     <option>Niger</option>
  700.     <option>Nigeria</option>
  701.     <option>Norway</option>
  702.     <option>Oman</option>
  703.     <option>Pakistan</option>
  704.     <option>Panama</option>
  705.     <option>Papua New Guinea</option>
  706.     <option>Paraguay</option>
  707.     <option>Peru</option>
  708.     <option>Philippines</option>
  709.     <option>Poland</option>
  710.     <option>Portugal</option>
  711.     <option>Puerto Rico</option>
  712.     <option>Romania</option>
  713.     <option>Russian Federation</option>
  714.     <option>Rwanda</option>
  715.     <option>Samoa</option>
  716.     <option>Saudi Arabia</option>
  717.     <option>Senegal</option>
  718.     <option>Seychelles</option>
  719.     <option>Sierra Leone</option>
  720.     <option>Singapore</option>
  721.     <option>Slovakia (Slovak Republic)</option>
  722.     <option>Slovenia</option>
  723.     <option>Somalia</option>
  724.     <option>South Africa</option>
  725.     <option>South Georgia</option>
  726.     <option>Spain</option>
  727.     <option>Sri Lanka</option>
  728.     <option>Sudan</option>
  729.     <option>Suriname</option>
  730.     <option>Swaziland</option>
  731.     <option>Sweden</option>
  732.     <option>Switzerland</option>
  733.     <option>Syrian Arab Republic</option>
  734.     <option>Taiwan</option>
  735.     <option>Tajikistan</option>
  736.     <option>Tanzania, United Republic of</option>
  737.     <option>Thailand</option>
  738.     <option>Togo</option>
  739.     <option>Tonga</option>
  740.     <option>Trinidad and Tobago</option>
  741.     <option>Tunisia</option>
  742.     <option>Turkey</option>
  743.     <option>Turkmenistan</option>
  744.     <option>Uganda</option>
  745.     <option>Ukraine</option>
  746.     <option>United Arab Emirates</option>
  747.     <option>United Kingdom</option>
  748.     <option>United States of America</option>
  749.     <option>Uruguay</option>
  750.     <option>Uzbekistan</option>
  751.     <option>Vatican City State (Holy See)</option>
  752.     <option>Venezuela</option>
  753.     <option>Viet Nam</option>
  754.     <option>Virgin Islands (British)</option>
  755.     <option>Virgin Islands (U.S.)</option>
  756.     <option>Western Sahara</option>
  757.     <option>Yemen</option>
  758.     <option>Yugoslavia</option>
  759.     <option>Zaire</option>
  760.     <option>Zambia</option>
  761.     <option>Zimbabwe</option>
  762. </select>
  763.     </td>
  764. </tr> 
  765.  
  766. <tr>
  767.       <td valign=middle>
  768.               Gender
  769.  
  770.     </td>
  771.     <td valign=top>
  772.             <select name=gender>
  773.     <option>%%gender%%</option>
  774.     <option></option>
  775.     <option>Male</option>
  776.     <option>Female</option>
  777. </select>
  778.     </td>
  779. </tr> 
  780.  
  781. <tr>
  782.       <td valign=middle>
  783.               Occupation
  784.  
  785.     </td>
  786.     <td valign=top>
  787.             <input type=text size=20 name=occupation value="%%occupation%%">
  788.     </td>
  789. </tr> 
  790.  
  791. <tr>
  792.       <td valign=top>
  793.               Hobbies
  794.  
  795.     </td>
  796.     <td valign=top>
  797.             <textarea wrap=virtual cols=40 rows=3 name=hobbies>%%hobbies%%</textarea>
  798.     </td>
  799. </tr> 
  800.  
  801. <tr>
  802.       <td valign=middle>
  803.               Homepage URL
  804.  
  805.     </td>
  806.     <td valign=top>
  807.             <input type=text size=20 name=homepage value="%%homepage%%">
  808.     </td>
  809. </tr> 
  810.  
  811. <tr>
  812.       <td valign=top>
  813.               Experience
  814.  
  815.     </td>
  816.     <td valign=top>
  817.             <textarea wrap=virtual cols=40 rows=3 name=any_experience>%%any_experience%%</textarea>
  818.     </td>
  819. </tr> 
  820.  
  821. <tr>
  822.       <td valign=middle>
  823.               height
  824.  
  825.     </td>
  826.     <td valign=top>
  827.             <select name=your_height>
  828.     <option>%%your_height%%</option>
  829.     <option></option>
  830.     <option>under 4 foot</option>
  831.     <option>4 foot 1 inch</option>
  832.     <option>4 foot 2 inch</option>
  833.     <option>4 foot 3 inch</option>
  834.     <option>4 foot 4 inch</option>
  835.     <option>4 foot 5 inch</option>
  836.     <option>4 foot 6 inch</option>
  837.     <option>4 foot 7 inch</option>
  838.     <option>4 foot 8 inch</option>
  839.     <option>4 foot 9 inch</option>
  840.     <option>4 foot 10 inch</option>
  841.     <option>4 foot 11 inch</option>
  842.     <option>4 foot 12 inch</option>
  843.     <option>5 foot</option>
  844.     <option>5 foot 1 inch</option>
  845.     <option>5 foot 2 inch</option>
  846.     <option>5 foot 3 inch</option>
  847.     <option>5 foot 4 inch</option>
  848.     <option>5 foot 5 inch</option>
  849.     <option>5 foot 6 inch</option>
  850.     <option>5 foot 7 inch</option>
  851.     <option>5 foot 8 inch</option>
  852.     <option>5 foot 9 inch</option>
  853.     <option>5 foot 10 inch</option>
  854.     <option>5 foot 11 inch</option>
  855.     <option>5 foot 12 inch</option>
  856.     <option>6 foot</option>
  857.     <option>6 foot 1 inch</option>
  858.     <option>6 foot 2 inch</option>
  859.     <option>6 foot 3 inch</option>
  860.     <option>6 foot 4 inch</option>
  861.     <option>6 foot 5 inch</option>
  862.     <option>6 foot 6 inch</option>
  863.     <option>6 foot 7 inch</option>
  864.     <option>6 foot 8 inch</option>
  865.     <option>6 foot 9 inch</option>
  866.     <option>6 foot 10 inch</option>
  867.     <option>6 foot 11 inch</option>
  868.     <option>6 foot 12 inch</option>
  869.     <option>7 foot</option>
  870.     <option>over 7 foot</option>
  871. </select>
  872.     </td>
  873. </tr> 
  874.  
  875. <tr>
  876.       <td valign=middle>
  877.               body type
  878.  
  879.     </td>
  880.     <td valign=top>
  881.             <select name=your_body>
  882.     <option>%%your_body%%</option>
  883.     <option></option>
  884.     <option>slim</option>
  885.     <option>average</option>
  886.     <option>athletic</option>
  887.     <option>large</option>
  888.     <option>extra large</option>
  889.     <option>muscular</option>
  890.     <option>other</option>
  891. </select>
  892.     </td>
  893. </tr> 
  894.  
  895. <tr>
  896.       <td valign=middle>
  897.               hair colour
  898.  
  899.     </td>
  900.     <td valign=top>
  901.             <select name=your_hair>
  902.     <option>%%your_hair%%</option>
  903.     <option></option>
  904.     <option>brown</option>
  905.     <option>blonde</option>
  906.     <option>black</option>
  907.     <option>red / ginger</option>
  908.     <option>white</option>
  909.     <option>grey</option>
  910.     <option>multi-coloured</option>
  911.     <option>other</option>
  912. </select>
  913.     </td>
  914. </tr> 
  915.  
  916. <tr>
  917.       <td valign=middle>
  918.               ethnicity
  919.  
  920.     </td>
  921.     <td valign=top>
  922.             <select name=your_ethnicity>
  923.     <option>%%your_ethnicity%%</option>
  924.     <option></option>
  925.     <option>white / caucasian</option>
  926.     <option>african american / black</option>
  927.     <option>asian</option>
  928.     <option>mixed race</option>
  929.     <option>oriental</option>
  930.     <option>hispanic</option>
  931.     <option>middle eastern</option>
  932.     <option>native american / indian</option>
  933.     <option>other</option>
  934. </select>
  935.     </td>
  936. </tr> 
  937.  
  938. <tr>
  939.       <td valign=middle>
  940.               fameage
  941.  
  942.     </td>
  943.     <td valign=top>
  944.             <select name=fameage>
  945.     <option>%%fameage%%</option>
  946.     <option></option>
  947.     <option>under 18</option>
  948.     <option>19 to 25</option>
  949.     <option>26 to 35</option>
  950.     <option>36 to 45</option>
  951.     <option>46 to 55</option>
  952.     <option>56 to 65</option>
  953.     <option>over 65</option>
  954. </select>
  955.     </td>
  956. </tr> 
  957.  
  958. <tr>
  959.       <td valign=middle>
  960.               basic or gold status
  961.  
  962.     </td>
  963.     <td valign=top>
  964.             <select name=basic-or-gold>
  965.     <option>%%basic-or-gold%%</option>
  966.     <option></option>
  967.     <option>basic</option>
  968.     <option>gold</option>
  969. </select>
  970.     </td>
  971. </tr> 
  972.  
  973. <tr>
  974.       <td valign=middle>
  975.               Main Interest
  976.  
  977.     </td>
  978.     <td valign=top>
  979.             <select name=main_interest>
  980.     <option>%%main_interest%%</option>
  981.     <option></option>
  982.     <option>Non professional</option>
  983.     <option>Film extra</option>
  984.     <option>Actor \ Actress</option>
  985.     <option>Model</option>
  986.     <option>Singer</option>
  987.     <option>Dancer</option>
  988.     <option>Stage Performer</option>
  989.     <option>Voice over artist</option>
  990.     <option>Band</option>
  991.     <option>Musician</option>
  992.     <option>Entertainer</option>
  993.     <option>Comedian</option>
  994.     <option>Magician</option>
  995.     <option>Recording studios / rehearsal rooms</option>
  996.     <option>Stage school</option>
  997.     <option>Photographer</option>
  998.     <option>Video and showreels</option>
  999.     <option>Training, coaching and tuition</option>
  1000.     <option>Film company</option>
  1001. </select>
  1002.     </td>
  1003. </tr> 
  1004.  
  1005. <tr>
  1006.       <td valign=middle>
  1007.               iagree
  1008.  
  1009.     </td>
  1010.     <td valign=top>
  1011.             <input type=hidden name=iagree value=no>
  1012.         <input type=checkbox name=iagree value=yes %%CHECKED:iagree%%> 
  1013.     </td>
  1014. </tr> 
  1015.  
  1016. <tr><td></td><td><input type=submit name=submit value="  Modify  ">
  1017. </form>
  1018. </td></table>


Any help with this would be massively appreciated

Thanks guys
Terry
Oct 2 '13 #1
3 2360
Rabbit
12,516 Expert Mod 8TB
That's a lot of code... it would help to know which lines you're referring to.
Oct 2 '13 #2
Hello, I dont know what line of code is causing the problem. 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
Oct 3 '13 #3
Rabbit
12,516 Expert Mod 8TB
Well, I don't know if many people would be up for reading a thousand lines of code to find the few lines that matter. So it would help if you could at least point out the lines that are supposed to be updating the data.
Oct 3 '13 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Steven | last post by:
I'm using VB6 and MySQL database server, I work fine for select statement and I can view the data but I can't "INSERT, UPDATE and DELETE" data at MySQL database. It return a error code "run-time...
4
by: Mmm_moo_cows | last post by:
Hi, I'm new to the world of mysql and i'm having alot of trouble with it. All i want to do is create a page with a response form, e.g. name etc and some radio buttons (part of a uni project,...
0
by: dave | last post by:
Please help! I have spent all weekend trying to solve this and its driving me mad! I have a form with a datagrid on. When I click button btnNew, the new row appears in the datagrid but it does...
7
by: mukeshpatil | last post by:
How to get data from .CSV file using php & store it into Mysql database I want to read data from two different .CSV files using php & How to store it into Mysql Database tables Please help me...
12
by: mistral | last post by:
phpMyAdmin 2.6.2 problem: can no connects to mySQL database: each time shown error #1045 - Access denied for user 'username'@'192.168.1.2' (using password: YES) Is seems, this is most common...
2
by: sookfuny1984 | last post by:
I am facing a problem on how to parse (analyze) apache log file (access or error file) so that the data in log file will be imported to MYSQL database?? anyone can help?
2
by: Mechul | last post by:
Hi people i need serious help here.. I have a forum and my hosting company suspended it cuz of the high usage of sql. We did everything to make lower the usage but its still high. it was ...
2
by: Zarwadi | last post by:
How do you count the number of rows in a mysql database. could anyone help
4
by: burrashiva | last post by:
Hi All, I have an Editor through which I want to send Greek Symbols for which I am using Α etc representation. I have an HTML template page where this Editor is called. Through MOOTOOLs...
4
by: Francesca | last post by:
Hi everybody, I am a real newbie in both perl and relational databases like mysql, and I have been banging my head on the wall trying to understand how to populate a mysql database using an Excel...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.