bdg3
-
Posts
3 -
Joined
-
Last visited
Never
bdg3's Achievements
Newbie (1/5)
0
Reputation
-
still getting the column count doesn't match value count @ row 1 after i have deleted the hadress_pcode that was entered twice. Here is the code of the form below aswell as this is driving me mad. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head> <title>Wooden Spoon: Northamptonshire - Home Page </title> <style type="text/css"> <!-- .style2 {font-family: Arial, Helvetica, sans-serif} body { background-color: #FFFFFF; } a:link { color : #999999 } .style3 { font-family: Arial, Helvetica, sans-serif; font-weight: bold; font-size: x-small; color: #FFFFFF; } .style4 { font-family: Arial, Helvetica, sans-serif; font-size: 24px; font-weight: bold; } .style5 {font-size: x-small} .style7 {color: #000066} a:hover { color: #0033FF; } .style33 {font-size: 14px} .style34 {font-size: 16px} .style35 {color: #FF0000} .style37 {color: #000000} --> </style> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head> <body> <table width="66%" border="0" cellpadding="0" cellspacing="0"> <tr> <td height="113" colspan="2"><a href="../index.php"><img src="images/title1.jpg" width="780" height="98" border="0"></a></td> </tr> <tr> <td width="35%"><img src="images/title2.jpg" width="266" height="63"></td> <td width="65%"> </td> </tr> </table> <table width="781" height="305" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="163" valign="top"><table width="160" border="0" cellspacing="5" cellpadding="0"> <tr> <td><a href="../index.php"><img src="images/menu/menu1.jpg" width="140" height="20" border="0"></a></td> </tr> <tr> <td><a href="../about_us.php"><img src="images/menu/menu2.jpg" width="140" height="20" border="0"></a></td> </tr> <tr> <td><img src="images/menu/menu3.jpg" width="140" height="20"></td> </tr> <tr> <td><a href="https://raptor.kent.ac.uk/~bdg3/php/project/member/membership.php"><img src="images/menu/menu4.jpg" width="140" height="20" border="0"></a></td> </tr> <tr> <td><img src="images/menu/menu5.jpg" width="140" height="20"></td> </tr> <tr> <td><img src="images/menu/menu6.jpg" width="140" height="20"></td> </tr> <tr> <td><img src="images/menu/menu7.jpg" width="140" height="20"></td> </tr> <tr> <td><img src="images/menu/menu8.jpg" width="140" height="20"></td> </tr> <tr> <td><img src="images/menu/menu9.jpg" width="140" height="20"></td> </tr> <tr> <td><img src="images/menu/menu10.jpg" width="140" height="20"></td> </tr> <tr> <td><img src="images/menu/menu11.jpg" width="140" height="20"></td> </tr> </table> <table width="159" height="145" border="1" align="right" cellpadding="2" cellspacing="0" bordercolor="#FF0033" bgcolor="#DDDDFF" id="login"> <tr> <td height="16" bgcolor="#FF0033" class="style3">Members Login</td> </tr> <tr> <td height="108" align="right" class="style2"><form name="form1" method="post" action="../admin.php"> <div align="left"> <p><span class="style5">Username:</span><br /> <input type="text" name="textfield"> <br /> <span class="style5">Password:</span><br /> <input type="text" name="textfield"> <br /> <input type="submit" name="Submit" value="Submit"> <input type="reset" name="Reset" value="Reset"> </p> </div> </form></td> </tr> </table> <p> </p></td> <td width ="10"> </td> <td width ="608" height="305" valign="top" bgcolor="#FFFFFF"> <p class="style4 style7">Membership</p> <p class="style4 style7 style34">Application Form</p> <table width="100%" border="0" cellpadding="0" cellspacing="5" bordercolor="#FFFFFF"> <form name="form2" method="post" action="mtransact.php"> <tr align="left" valign="top"> <td width="28%"><span class="style35">Title:</span></td> <td width="25%"> <select name="title"> <option selected>Mr</option> <option>Mrs</option> <option>Miss</option> <option>Ms</option> <option>Dr</option> <option>Other</option> </select> </td> <td width="21%" colspan="2" class="style35"><p align="left">Date of Birth: <select name="dob_day" size="1"> <option selected="selected">01</option> <option>02</option> <option>03</option> <option>04</option> <option>05</option> <option>06</option> <option>07</option> <option>08</option> <option>09</option> <option>10</option> <option>11</option> <option>12</option> <option>13</option> <option>14</option> <option>15</option> <option>16</option> <option>17</option> <option>18</option> <option>19</option> <option>20</option> <option>21</option> <option>22</option> <option>23</option> <option>24</option> <option>25</option> <option>26</option> <option>27</option> <option>28</option> <option>29</option> <option>30</option> <option>31</option> </select> <span class="style37">/</span> <select name="dob_month" size="1"> <option selected="selected">01</option> <option>02</option> <option>03</option> <option>04</option> <option>05</option> <option>06</option> <option>07</option> <option>08</option> <option>09</option> <option>10</option> <option>11</option> <option>12</option> </select> <span class="style37"> /</span> <select name="dob_year" size="1"> <option selected="selected">1910</option> <option>1911</option> <option>1912</option> <option>1913</option> <option>1914</option> <option>1915</option> <option>1916</option> <option>1917</option> <option>1918</option> <option>1919</option> <option>1920</option> <option>1921</option> <option>1922</option> <option>1923</option> <option>1924</option> <option>1925</option> <option>1926</option> <option>1927</option> <option>1928</option> <option>1929</option> <option>1930</option> <option>1931</option> <option>1932</option> <option>1933</option> <option>1934</option> <option>1935</option> <option>1936</option> <option>1937</option> <option>1938</option> <option>1939</option> <option>1940</option> <option>1941</option> <option>1942</option> <option>1943</option> <option>1944</option> <option>1945</option> <option>1946</option> <option>1947</option> <option>1948</option> <option>1949</option> <option>1950</option> <option>1951</option> <option>1952</option> <option>1953</option> <option>1954</option> <option>1955</option> <option>1956</option> <option>1957</option> <option>1958</option> <option>1959</option> <option>1960</option> <option>1961</option> <option>1962</option> <option>1963</option> <option>1964</option> <option>1965</option> <option>1966</option> <option>1967</option> <option>1968</option> <option>1969</option> <option>1970</option> <option>1971</option> <option>1972</option> <option>1973</option> <option>1974</option> <option>1975</option> <option>1976</option> <option>1977</option> <option>1978</option> <option>1979</option> <option>1980</option> <option>1981</option> <option>1982</option> <option>1983</option> <option>1984</option> <option>1985</option> <option>1986</option> <option>1987</option> <option>1988</option> <option>1989</option> <option>1990</option> <option>1991</option> <option>1993</option> <option>1994</option> <option>1995</option> <option>1996</option> <option>1997</option> <option>1998</option> <option>1999</option> <option>2000</option> <option>2001</option> <option>2002</option> <option>2003</option> <option>2004</option> <option>2005</option> <option>2006</option> </select> <span class="style37">(dd/mm/yyyy)</span> </p> </td> </tr> <tr align="left" valign="top"> <td class="style35">Surname:</td> <td><input name="surname" type="text" value=" "></td> <td width="21%" class="style35">Forename:</td> <td width="26%"><input name="forename" type="text" value=" "></td> </tr> <tr align="left" valign="top"> <td colspan="4"> </td> </tr> <tr align="left" valign="top"> <td colspan="2">Home Address </td> <td colspan="2">Work Address </td> </tr> <tr align="left" valign="top"> <td class="style35">Line 1 </td> <td><input name="haddress_line1" type="text" value=" "></td> <td>Line 1 </td> <td><input name="waddress_line1" type="text"></td> </tr> <tr align="left" valign="top"> <td>Line 2 </td> <td><input type="text" name="haddress_line2"></td> <td>Line 2 </td> <td><input type="text" name="waddress_line2"></td> </tr> <tr align="left" valign="top"> <td>Line 3 </td> <td><input type="text" name="haddress_line3"></td> <td>Line 3 </td> <td><input type="text" name="waddress_line3"></td> </tr> <tr align="left" valign="top"> <td class="style35">Town/City</td> <td><input name="haddress_town_city" type="text" value=" "></td> <td>Town/City</td> <td><input type="text" name="waddress_town_city"></td> </tr> <tr align="left" valign="top"> <td class="style35">County</td> <td><input name="haddress_county" type="text" value=" "></td> <td>County</td> <td><input type="text" name="waddress_county"></td> </tr> <tr align="left" valign="top"> <td class="style35">Post Code </td> <td><input type="text" name="haddress_pcode"></td> <td>Post Code </td> <td><input type="text" name="waddress_pcode"></td> </tr> <tr align="left" valign="top"> <td colspan="4"> </td> </tr> <tr align="left" valign="top"> <td class="style35">Daytime Telephone:</td> <td><input name="day_num" type="text" value="0"></td> <td>Evening Telephone:</td> <td><input type="text" name="eve_num"></td> </tr> <tr align="left" valign="top"> <td>Mobile:</td> <td><input type="text" name="mobile_num"></td> <td>Fax:</td> <td><input type="text" name="fax_num"></td> </tr> <tr align="left" valign="top"> <td height="22" class="style35">E-mail:</td> <td><input name="email" type="text" value=" "></td> <td> </td> <td> </td> </tr> <tr align="left" valign="top"> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr align="left" valign="top"> <td><span class="style35">Occupation</span>:</td> <td> <select name="occupation"> <option selected>None</option> <option>Director</option> <option>Manager</option> <option>Media</option> <option>Retired</option> <option>Self Employed</option> <option>Housewife</option> <option>Clerical/Administration</option> <option>Medical/Health care</option> <option>Legal</option> <option>Operative</option> <option>Education</option> <option>Other</option> </select> </td> <td class="style35">Interest 1:</td> <td> <select name="interest1"> <option>None</option> <option selected>Rugby</option> <option>Golf</option> <option>Football</option> <option>Cricket</option> <option>Tennis</option> <option>Gardening</option> <option>Food</option> <option>Wine</option> <option>Arts & Crafts</option> <option>DIY</option> </select> </td> </tr> <tr align="left" valign="top"> <td><span class="style35">Region</span>:</td> <td><select name="region" size="1"> <option selected="selected">Northamptonshire</option> <option>Cambridgeshire</option> </select></td> <td class="style35">Interest 2:</td> <td> <select name="interest2"> <option>None</option> <option>Rugby</option> <option selected="selected">Golf</option> <option>Football</option> <option>Cricket</option> <option>Tennis</option> <option>Gardening</option> <option>Food</option> <option>Wine</option> <option>Arts & Crafts</option> <option>DIY</option> </select> </td> </tr> <tr align="left" valign="top"> <td class="style35">Gift Aid Subcriber:</td> <td><select name="gift_aid_sub" size="1"> <option selected="selected">Yes</option> <option>No</option> </select></td> <td class="style35">Interest 3:</td> <td> <select name="interest3"> <option>None</option> <option>Rugby</option> <option>Golf</option> <option selected="selected">Football</option> <option>Cricket</option> <option>Tennis</option> <option>Gardening</option> <option>Food</option> <option>Wine</option> <option>Arts & Crafts</option> <option>DIY</option> </select> </td> </tr> <tr align="left" valign="top"> <td class="style35">Rugby Club Member</td> <td><select name="rugby_club_mem" size="1"> <option selected="selected">Yes</option> <option>No</option> </select></td> <td>:Rugby Club Name:</td> <td><input type="text" name="rugby_club_name"></td> </tr> <tr> <td colspan="4"> </td> </tr> <tr class="style4 style7 style33"> <td colspan="4">For Office Use Only</td> </tr> <tr class="style4 style7 style33"> <td colspan="4"> </td> </tr> <tr> <td>Mailing List ID</td> <td><select name="ml_id"> <option selected="selected">1</option> </select></td> <td>Location Joined At</td> <td><select name="loc_joined_at" size="1"> <option selected="selected">Online Form</option> </select></td> </tr> <tr> <td colspan="2">Membership Starting Date: <input type="text" name="mem_start_date" /></td> <td colspan="2"> </td> </tr> <tr> <td colspan="4"><span class="style4 style7 style33"> <input name="submit" type="submit" value="submit" /> <input name="reset" type="reset" value="reset" /> </span> </td> </tr></form> </table> <p class="style4 style7 style33"> </p></td> </tr></form> </table> </body> </html>
-
Ive deleted that and counted up the fields and they all match, 34 not including the autoincrement field and it still doesnt want to work, any more ideas?
-
I have an error appearing when tryon to submit data through php from mysql, column count doesnt match value count at row 1. I thought it would be spelling but i cant find it. here is the php code <?php require ('config.php'); $conn = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS) or die ('Could not connect to MySQL Database. ' . mysql_error()); mysql_select_db("bdg3"); $sql1 = "INSERT INTO members (surname,forename,title,date_of_birth,haddress_line1,haddress_line2,haddress_line3,haddress_town_city,haddress_county,haddress_pcode,waddress_line1,waddress_line2, waddress_line3,waddress_town_city,waddress_county,waddress_pcode,day_num,eve_num,mobile_num,fax_num,email,occupation,interest1,interest2,interest3,mem_start_date,loc_joined_at,region,ml_id, gift_aid_sub,rugby_club_mem,rugby_club_name) " . "VALUES (' " . $_POST['surname'] . "',' " . $_POST['forename'] . "',' " . $_POST['title'] . "',' " . $_POST['dob_day'] . "',' " . $_POST['dob_month'] . "',' " . $_POST['dob_year'] . "'," . "'" . $_POST['haddress_line1'] . "',' " . $_POST['haddress_line2'] . "',' " . $_POST['haddress_line3'] . "',' " . $_POST['haddress_town_city'] . "'," . "'" . $_POST['haddress_county'] . "',' " . $_POST['haddress_pcode'] . "',' " . $_POST['haddress_pcode'] . "',' " . $_POST['waddress_line1'] . "',". "'" . $_POST['waddress_line2'] . "',' " . $_POST['waddress_line3'] . "',' " . $_POST['waddress_town_city'] . "',' " . $_POST['waddress_county'] . "'," . "'" . $_POST['waddress_pcode'] . "',' " . $_POST['day_num'] . "',' " . $_POST['eve_num'] . "',' " . $_POST['mobile_num'] . "'," . "'" . $_POST['fax_num'] . "',' " . $_POST['email'] . "',' " . $_POST['occupation'] . "',' " . $_POST['interest1'] . "'," . "'" . $_POST['interest2'] . "',' " . $_POST['interest3'] . "',' " . $_POST['mem_start_date'] . "',' " . $_POST['loc_joined_at'] . "'," . "'" . $_POST['region'] . "',' " . $_POST['ml_id'] . "',' " . $_POST['gift_aid_sub'] . "',' " . $_POST['rugby_club_mem'] . "'," . "'" . $_POST['rugby_club_name'] . "');"; mysql_query($sql1) or die ('Could not add user. ' . mysql_error()); echo ('Thankyou, you have success fully managed to add a new member.'); ?> and this is the table creation code. $SQL1 = "CREATE TABLE IF NOT EXISTS members ( member_id int(6) NOT NULL auto_increment, surname varchar(20) NOT NULL default '', forename varchar(20) NOT NULL default '', title enum('Mr','Mrs','Miss','Dr','Ms', 'Other') NOT NULL default 'Mr', dob_day int(2)NOT NULL default '1', dob_month int(2)NOT NULL default '1', dob_year int(4)NOT NULL default '1910', haddress_line1 varchar(20) NOT NULL, haddress_line2 varchar(20), haddress_line3 varchar(20), haddress_town_city varchar(20) NOT NULL, haddress_county varchar(20) NOT NULL, haddress_pcode varchar(8) NOT NULL, waddress_line1 varchar(20), waddress_line2 varchar(20), waddress_line3 varchar(20), waddress_town_city varchar(20), waddress_county varchar(20), waddress_pcode varchar(8), day_num int(12) NOT NULL, eve_num int(12), mobile_num int(12), fax_num int(12), email varchar(40) NOT NULL, occupation enum('None','Director','Manager','Media','Retired','Self Employed','House Wife','Clerical/Administration','Medical/Healthcare','Legal','Operative','Education','Other')NOT NULL default 'None', interest1 enum('rugby','football','golf','cricket','tennis','gardening','food','wine','arts & crafts','DIY') NOT NULL default 'rugby', interest2 enum('rugby','football','golf','cricket','tennis','gardening','food','wine','arts & crafts','DIY'), interest3 enum('rugby','football','golf','cricket','tennis','gardening','food','wine','arts & crafts','DIY'), mem_start_date date NOT NULL, loc_joined_at enum('None','Mailing','At an Event','Online Form','Other') NOT NULL, region enum('Northamptonshire','Cambridge','Other') NOT NULL default 'Northamptonshire', ml_id enum('1') NOT NULL default '1', gift_aid_sub enum('yes','no') NOT NULL default 'yes', rugby_club_mem enum('yes','no') NOT NULL, rugby_club_name varchar(30), PRIMARY KEY (member_id)) TYPE=MyISAM"; If you want the form code aswell i can provide that too. please help. Thankyou