SQL syntax error

This is a discussion on "SQL syntax error" within the PHP Forum section. This forum, and the thread "SQL syntax error are both part of the Program Your Website category.


 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Program Your Website > PHP Forum
Reload this Page SQL syntax error

Notices
Please Register!
Webforumz.com is an education based community supporting web designers, developers and those who are new and learning. If you are a designer, developer, learning web design or are thinking about a career in web design then you have come to the right place. Register for free now to access more information and to participate in discussion and debate.




Reply
 
LinkBack Thread Tools
  #1  
Old Jun 20th, 2008, 03:34
Junior Member
Join Date: Dec 2007
Location: Indiana
Age: 28
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Post SQL syntax error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tables, keyboard, machine) VALUES ('email','username', (PASSWORD('password' at line 1

I've done some searching and I can't seem to find a straight answer for this error. This error comes up after filling out a registration form on my website. Everything worked fine before I added 7 checkboxes. Each check box has its own field on my database so that I can provide detailed searches according to the boxes checked. Any advice or assistance given is thanked in advance.

By the way.... I'm diggin the new site layout, this place is great.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

  #2  
Old Jun 20th, 2008, 09:23
Jack Franklin's Avatar
Moderator

SuperMember
Join Date: May 2007
Location: Cornwall, England
Posts: 1,410
Blog Entries: 8
Thanks: 18
Thanked 14 Times in 14 Posts
Re: SQL syntax error
Could I see the code please? The intire form + the PHP/MySQL for it.
__________________
Jack Franklin - Webforumz Moderator
(x)HTML | CSS | PHP | MySQL | JQuery (Javascript)
Contact: My Blog | Twitter | Delicious
 Want Lessons? PM me.
 If you think I've helped, please press the 'Thanks' Button.
Last Blog Entry: A Week with VBulletin (Aug 28th, 2008)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old Jun 20th, 2008, 11:09
Most Reputable Member
Join Date: Feb 2004
Location: Borneo
Age: 27
Posts: 1,612
Blog Entries: 2
Thanks: 0
Thanked 4 Times in 3 Posts
Re: SQL syntax error
What I need is just the print screen at your popup error
Last Blog Entry: ASP Programming Tips and Technique (Oct 26th, 2007)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4  
Old Jun 20th, 2008, 13:47
Junior Member
Join Date: Dec 2007
Location: Indiana
Age: 28
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Re: SQL syntax error
PHP code from registration page


PHP: Select all

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
 
 <title></title>
 <link rel="stylesheet" href="style.css" type="text/css" charset="utf-8" />
 <style type="text/css">
<!--
.style1 {
 font-size: 36px;
 font-weight: bold;
 color: #FFFFFF;
 font-family: Rockwell;
}
.style2 {font-size: 14px}
.style3 {font-size: 16px}
-->
    </style>
</head>
 
<body>
 
 
 
  <div id="wrapper">
    <h1>&nbsp;</h1>
    <div id="nav">
      <ul>
        <li><a href="index.htm">HOME</a></li>
        <li><a href="index.htm">BANDS</a></li>
        <li><a href="index.htm">ARTISTS</a></li>
        <li><a href="index.htm">GALLERY</a></li>
        <li><a href="index.htm">VENUES</a></li>
        <li><a href="index.htm">STUDIOS</a></li>
  <li><a href="temp/register.php">SIGN UP</a></li>
        <li></li>
      </ul>
    </div>
<table bgcolor="">
<tr>
 <td><span class="style1"></span></td>
  </tr>
   </table>
    <div id="content" align="center">
  <form name="login" id="login" method="post" action="#">
   <label>Username:
    <input name="user" type="text" id="user" tabindex="1" class="text"></label> 
     <label>Password:
      <input name="password" type="password" id="password" tabindex="2" class="text"> 
       <input type="submit" name="Submit" value="Login" tabindex="3" />
        </label> 
         </form>
 
      <div id="body">
<?php
include "conn.inc.php";
?>
<?php
if (isset($_POST['submit']) && $_POST['submit'] == "Register") {
  if ($_POST['username'] != " " && 
      $_POST['password'] != " " &&
   $_POST['first_name'] != " " &&
   $_POST['last_name'] != " " &&
   $_POST['email'] != " ") {
 
 $query = "SELECT username FROM user_info " .
          "WHERE username = '" . $_POST['username'] . "';";
 $result = mysql_query($query)
   or die(mysql_error());
 
 if (mysql_num_rows($result) != 0) {
?>
<p class="style1 style3"><center>  The Username,
  <?php echo $_POST['username']; ?>, is already in use, please choose another!</center>
 
  <form action="register.php" method="post">
<table align="center">
<tr>
 <td align="right"><span class="style2"><b>First Name:</b></span></td> 
  <td align="left"><input name="first_name" type="text" value="<?php echo $_POST['first_name']; ?>"></td>
   <td align="right"><span class="style2"><b>Last Name:</b></span></td> 
    <td align="left"><input type="text" name="last_name" value="<?php echo $_POST['last_name']; ?>"></td>
     </tr>
<tr>
 <td align="right"><span class="style2"><b>Username:</b></span></td>
  <td align="left"><input type="text" name="username" value="<?php echo $_POST['username']; ?>"></td>
   <td align="right"><span class="style2"><b>Password:</b></span></td> 
    <td align="left"><input type="password" name="password" value="<?php echo $_POST['password']; ?>"></td>
     </tr>
<tr>
 <td align="right"><span class="style2"><b>Email:</b></span></td> 
  <td align="left"><input type="text" name="email" value="<?php echo $_POST['email']; ?>"></td>
   <td align="right"><span class="style2"><b>Address:</b></span></td> 
    <td align="left"><input type="text" name="address" value="<?php echo $_POST['address']; ?>"></td>
     </tr>
<tr> 
 <td align="right"><span class="style2"><b>City:</b></span></td> 
  <td align="left"><input type="text" name="city" value="<?php echo $_POST['city']; ?>"></td>
   <td align="right"><span class="style2"><b>State:</b></span></td>
    <td align="left"><select name="state[]">
 <option value="Alabama" <?php  $_POST['state'] ?>>Alabama</option>
 <option value="Alaska" <?php  $_POST['state'] ?>>Alaska</option>
 <option value="Arizona" <?php $_POST['state'] ?>>Arizona</option>
 <option value="Arkansas" <?php $_POST['state'] ?>>Arkansas</option>
 <option value="California" <?php $_POST['state'] ?>>California</option>
 <option value="Colorado" <?php $_POST['state'] ?>>Colorado</option>
 <option value="Connecticut" <?php $_POST['state'] ?>>Connecticut</option>
 <option value="Delaware" <?php $_POST['state'] ?>>Delaware</option>
 <option value="Florida" <?php $_POST['state'] ?>>Florida</option>
 <option value="Georgia" <?php $_POST['state'] ?>>Georgia</option>
 <option value="Hawaii" <?php $_POST['state'] ?>>Hawaii</option>
 <option value="Idaho" <?php $_POST['state'] ?>>Idaho</option>
 <option value="Illinois" <?php $_POST['state'] ?>>Illinois</option>
 <option value="Indiana" <?php $_POST['state'] ?>>Indiana</option>
 <option value="Iowa" <?php $_POST['state'] ?>>Iowa</option>
 <option value="Kansas" <?php $_POST['state'] ?>>Kansas</option>
 <option value="Kentucky" <?php $_POST['state'] ?>>Kentucky</option>
 <option value="Louisiana" <?php $_POST['state'] ?>>Louisiana</option>
 <option value="Maine" <?php $_POST['state'] ?>>Maine</option>
 <option value="Maryland" <?php $_POST['state'] ?>>Maryland</option>
 <option value="Massachusetts" <?php $_POST['state'] ?>>Massachusetts</option>
 <option value="Michigan" <?php $_POST['state'] ?>>Michigan</option>
 <option value="Minnesota" <?php $_POST['state'] ?>>Minnesota</option>
 <option value="Mississippi" <?php $_POST['state'] ?>>Mississippi</option> 
 <option value="Missouri" <?php $_POST['state'] ?>>Missouri</option>
 <option value="Montana" <?php $_POST['state'] ?>>Montana</option>
 <option value="Nebraska" <?php $_POST['state'] ?>>Nebraska</option>
 <option value="Nevada" <?php $_POST['state'] ?>>Nevada</option>
 <option value="New Hampshire" <?php $_POST['state'] ?>>New Hampshire</option>
 <option value="New Jersey" <?php $_POST['state'] ?>>New Jersey</option>
 <option value="New Mexico" <?php $_POST['state'] ?>>New Mexico</option>
 <option value="New York" <?php $_POST['state'] ?>>New York</option>
 <option value="North Carolina" <?php $_POST['state'] ?>>North Carolina</option>
 <option value="North Dakota" <?php $_POST['state'] ?>>North Dakota</option>
 <option value="Ohio" <?php $_POST['state'] ?>>Ohio</option>
 <option value="Oklahoma" <?php $_POST['state'] ?>>Oklahoma</option>
 <option value="Oregon" <?php $_POST['state'] ?>>Oregon</option>
 <option value="Pennsylvania" <?php $_POST['state'] ?>>Pennsylvania</option>
 <option value="Rhode Island" <?php $_POST['state'] ?>>Rhode Island</option>
 <option value="South Carolina" <?php $_POST['state'] ?>>South Carolina</option>
 <option value="South Dakota" <?php $_POST['state'] ?>>South Dakota</option>
 <option value="Tennessee" <?php $_POST['state'] ?>>Tennessee</option>
 <option value="Texas" <?php $_POST['state'] ?>>Texas</option>
 <option value="Utah" <?php $_POST['state'] ?>>Utah</option>
 <option value="Vermont" <?php $_POST['state'] ?>>Vermont</option>
 <option value="Virginia" <?php $_POST['state'] ?>>Virginia</option>
 <option value="Washington" <?php $_POST['state'] ?>>Washington</option>
 <option value="Washington D.C." <?php $_POST['state'] ?>>Washington D.C.</option>
 <option value="West Virginia" <?php $_POST['state'] ?>>West Virginia</option>
 <option value="Wisconsin" <?php $_POST['state'] ?>>Wisconsin</option>
 <option value="Wyoming" <?php $_POST['state'] ?>>Wyoming</option>
 </select>
 </td>
  </tr>
   </table>
 
 
<table align="center">
 <tr>
  <td><span class="style2"><b>Musical talent:</b></span></td>
   <td><input type="checkbox" width="50" name="Vocals" value="<?php echo $_POST['talent']; ?>">Vocals
       <input type="checkbox" width="50" name="Guitar" value="<?php echo $_POST['talent']; ?>">Guitar
    <input type="checkbox" width="50" name="Bass Guitar" value="<?php echo $_POST['talent']; ?>">Bass Guitar
    <input type="checkbox" width="50" name="Drums" value="<?php echo $_POST['talent']; ?>">Drums
    <input type="checkbox" width="50" name="Turn Tables" value="<?php echo $_POST['talent']; ?>">Turn Tables
    <input type="checkbox" width="50" name="Keyboard" value="<?php echo $_POST['talent']; ?>">Keyboard
    <input type="checkbox" width="50" name="Drum Machine" value="<?php echo $_POST['talent']; ?>">Drum Machine
       <input type="checkbox" width="50" name="Other" value="<?php echo $_POST['talent']; ?>">Other
     </td>
      </tr>  
          </table>
 
 
<table align="center">
<tr>
 <td><input type="submit" name="submit" value="Register"> &nbsp;
     <input type="reset" value="clear">
</td>
</tr>
</table>
</form>
</p>
<?php
 } else {
   $query = 
"INSERT INTO user_info (email, username, password, " . "first_name, last_name, address, city, state, vocals, guitar, bass, drums, tables, keyboard, machine) " .
"VALUES ('" . $_POST['email'] . "','" . $_POST['username'] . "', " . "(PASSWORD('" . $_POST['password'] . "')), '" . $_POST['first_name'] . "', '" . $_POST['last_name'] . "', '" . $_POST['address'] . "', '" . $_POST['city'] . "', '" . implode(", ", $_POST['state']) . "', '" . $_POST['vocals'] . "', '" . $_POST['guitar'] . "', '" . $_POST['bass'] . "', '" . $_POST['drums'] . "', '" . $_POST['tables'] . "', '" . $_POST['keyboard'] . "', '" . $_POST['machine'] . "');";  
$result = mysql_query($query)
  or die(mysql_error());
$_SESSION['user_logged'] = $_POST['username'];
$_SESSION['user_password'] = $_POST['password'];
?>
<p>
  Thank you for registering! <?php echo $_POST['first_name'] . " " .$_POST['last_name']; ?> You may now <a href="user_personal.php"> Click here</a> to access your personal page. <br>
<?php
 
   echo " ";
   die();
 }
} else {
?>
</p>
<p>
  <center><font color="#FF0000"><b>The Username, Password, Email, First Name, and Last Name fields are required!</b></font></center>
    <form action="register.php" method="post">
<table align="center">
<tr>
 <td align="right"><span class="style2"><b>First Name:</b></span></td> 
  <td align="left"><input name="first_name" type="text" value="<?php echo $_POST['first_name']; ?>"></td>
   <td align="right"><span class="style2"><b>Last Name:</b></span></td> 
    <td align="left"><input type="text" name="last_name" value="<?php echo $_POST['last_name']; ?>"></td>
     </tr>
<tr>
 <td align="right"><span class="style2"><b>Username:</b></span></td>
  <td align="left"><input type="text" name="username" value="<?php echo $_POST['username']; ?>"></td>
   <td align="right"><span class="style2"><b>Password:</b></span></td> 
    <td align="left"><input type="password" name="password" value="<?php echo $_POST['password']; ?>"></td>
     </tr>
<tr>
 <td align="right"><span class="style2"><b>Email:</b></span></td> 
  <td align="left"><input type="text" name="email" value="<?php echo $_POST['email']; ?>"></td>
   <td align="right"><span class="style2"><b>Address:</b></span></td> 
    <td align="left"><input type="text" name="address" value="<?php echo $_POST['address']; ?>"></td>
     </tr>
<tr> 
 <td align="right"><span class="style2"><b>City:</b></span></td> 
  <td align="left"><input type="text" name="city" value="<?php echo $_POST['city']; ?>"></td>
   <td align="right"><span class="style2"><b>State:</b></span></td>
    <td align="left"><select name="state[]">
 <option value="Alabama" <?php  $_POST['state'] ?>>Alabama</option>
 <option value="Alaska" <?php  $_POST['state'] ?>>Alaska</option>
 <option value="Arizona" <?php $_POST['state'] ?>>Arizona</option>
 <option value="Arkansas" <?php $_POST['state'] ?>>Arkansas</option>
 <option value="California" <?php $_POST['state'] ?>>California</option>
 <option value="Colorado" <?php $_POST['state'] ?>>Colorado</option>
 <option value="Connecticut" <?php $_POST['state'] ?>>Connecticut</option>
 <option value="Delaware" <?php $_POST['state'] ?>>Delaware</option>
 <option value="Florida" <?php $_POST['state'] ?>>Florida</option>
 <option value="Georgia" <?php $_POST['state'] ?>>Georgia</option>
 <option value="Hawaii" <?php $_POST['state'] ?>>Hawaii</option>
 <option value="Idaho" <?php $_POST['state'] ?>>Idaho</option>
 <option value="Illinois" <?php $_POST['state'] ?>>Illinois</option>
 <option value="Indiana" <?php $_POST['state'] ?>>Indiana</option>
 <option value="Iowa" <?php $_POST['state'] ?>>Iowa</option>
 <option value="Kansas" <?php $_POST['state'] ?>>Kansas</option>
 <option value="Kentucky" <?php $_POST['state'] ?>>Kentucky</option>
 <option value="Louisiana" <?php $_POST['state'] ?>>Louisiana</option>
 <option value="Maine" <?php $_POST['state'] ?>>Maine</option>
 <option value="Maryland" <?php $_POST['state'] ?>>Maryland</option>
 <option value="Massachusetts" <?php $_POST['state'] ?>>Massachusetts</option>
 <option value="Michigan" <?php $_POST['state'] ?>>Michigan</option>
 <option value="Minnesota" <?php $_POST['state'] ?>>Minnesota</option>
 <option value="Mississippi" <?php $_POST['state'] ?>>Mississippi</option> 
 <option value="Missouri" <?php $_POST['state'] ?>>Missouri</option>
 <option value="Montana" <?php $_POST['state'] ?>>Montana</option>
 <option value="Nebraska" <?php $_POST['state'] ?>>Nebraska</option>
 <option value="Nevada" <?php $_POST['state'] ?>>Nevada</option>
 <option value="New Hampshire" <?php $_POST['state'] ?>>New Hampshire</option>
 <option value="New Jersey" <?php $_POST['state'] ?>>New Jersey</option>
 <option value="New Mexico" <?php $_POST['state'] ?>>New Mexico</option>
 <option value="New York" <?php $_POST['state'] ?>>New York</option>
 <option value="North Carolina" <?php $_POST['state'] ?>>North Carolina</option>
 <option value="North Dakota" <?php $_POST['state'] ?>>North Dakota</option>
 <option value="Ohio" <?php $_POST['state'] ?>>Ohio</option>
 <option value="Oklahoma" <?php $_POST['state'] ?>>Oklahoma</option>
 <option value="Oregon" <?php $_POST['state'] ?>>Oregon</option>
 <option value="Pennsylvania" <?php $_POST['state'] ?>>Pennsylvania</option>
 <option value="Rhode Island" <?php $_POST['state'] ?>>Rhode Island</option>
 <option value="South Carolina" <?php $_POST['state'] ?>>South Carolina</option>
 <option value="South Dakota" <?php $_POST['state'] ?>>South Dakota</option>
 <option value="Tennessee" <?php $_POST['state'] ?>>Tennessee</option>
 <option value="Texas" <?php $_POST['state'] ?>>Texas</option>
 <option value="Utah" <?php $_POST['state'] ?>>Utah</option>
 <option value="Vermont" <?php $_POST['state'] ?>>Vermont</option>
 <option value="Virginia" <?php $_POST['state'] ?>>Virginia</option>
 <option value="Washington" <?php $_POST['state'] ?>>Washington</option>
 <option value="Washington D.C." <?php $_POST['state'] ?>>Washington D.C.</option>
 <option value="West Virginia" <?php $_POST['state'] ?>>West Virginia</option>
 <option value="Wisconsin" <?php $_POST['state'] ?>>Wisconsin</option>
 <option value="Wyoming" <?php $_POST['state'] ?>>Wyoming</option>
 </select>
 </td>
  </tr>
   </table>
 
 
<table align="center">
 <tr>
  <td><span class="style2"><b>Musical talent:</b></span></td>
   <td><input type="checkbox" width="50" name="Vocals" value="<?php echo $_POST['talent']; ?>">Vocals
       <input type="checkbox" width="50" name="Guitar" value="<?php echo $_POST['talent']; ?>">Guitar
    <input type="checkbox" width="50" name="Bass Guitar" value="<?php echo $_POST['talent']; ?>">Bass Guitar
    <input type="checkbox" width="50" name="Drums" value="<?php echo $_POST['talent']; ?>">Drums
    <input type="checkbox" width="50" name="Turn Tables" value="<?php echo $_POST['talent']; ?>">Turn Tables
    <input type="checkbox" width="50" name="Keyboard" value="<?php echo $_POST['talent']; ?>">Keyboard
    <input type="checkbox" width="50" name="Drum Machine" value="<?php echo $_POST['talent']; ?>">Drum Machine
     </td>
      </tr>  
          </table>
 
 
<table align="center">
<tr>
 <td><input type="submit" name="submit" value="Register"> &nbsp;
     <input type="reset" value="clear">
</td>
</tr>
</table>
</form>
</p>
<?php
  }
} else {
?>
<table align="center" bgcolor="#FFFFFF">
 <tr>
  <td align="center"><b><font color="#FF0000">Welcome to the registration page! All fields are required.</font></b></td>
   </tr>
    </table>
  <form action="register.php" method="post">
<table align="center">
<tr>
 <td align="right"><span class="style2"><b>First Name:</b></span></td> 
  <td align="left"><input name="first_name" type="text" value="<?php echo $_POST['first_name']; ?>"></td>
   <td align="right"><span class="style2"><b>Last Name:</b></span></td> 
    <td align="left"><input type="text" name="last_name" value="<?php echo $_POST['last_name']; ?>"></td>
     </tr>
<tr>
 <td align="right"><span class="style2"><b>Username:</b></span></td>
  <td align="left"><input type="text" name="username" value="<?php echo $_POST['username']; ?>"></td>
   <td align="right"><span class="style2"><b>Password:</b></span></td> 
    <td align="left"><input type="password" name="password" value="<?php echo $_POST['password']; ?>"></td>
     </tr>
<tr>
 <td align="right"><span class="style2"><b>Email:</b></span></td> 
  <td align="left"><input type="text" name="email" value="<?php echo $_POST['email']; ?>"></td>
   <td align="right"><span class="style2"><b>Address:</b></span></td> 
    <td align="left"><input type="text" name="address" value="<?php echo $_POST['address']; ?>"></td>
     </tr>
<tr> 
 <td align="right"><span class="style2"><b>City:</b></span></td> 
  <td align="left"><input type="text" name="city" value="<?php echo $_POST['city']; ?>"></td>
   <td align="right"><span class="style2"><b>State:</b></span></td>
    <td align="left"><select name="state[]">
 <option value="Alabama" <?php  $_POST['state'] ?>>Alabama</option>
 <option value="Alaska" <?php  $_POST['state'] ?>>Alaska</option>
 <option value="Arizona" <?php $_POST['state'] ?>>Arizona</option>
 <option value="Arkansas" <?php $_POST['state'] ?>>Arkansas</option>
 <option value="California" <?php $_POST['state'] ?>>California</option>
 <option value="Colorado" <?php $_POST['state'] ?>>Colorado</option>
 <option value="Connecticut" <?php $_POST['state'] ?>>Connecticut</option>
 <option value="Delaware" <?php $_POST['state'] ?>>Delaware</option>
 <option value="Florida" <?php $_POST['state'] ?>>Florida</option>
 <option value="Georgia" <?php $_POST['state'] ?>>Georgia</option>
 <option value="Hawaii" <?php $_POST['state'] ?>>Hawaii</option>
 <option value="Idaho" <?php $_POST['state'] ?>>Idaho</option>
 <option value="Illinois" <?php $_POST['state'] ?>>Illinois</option>
 <option value="Indiana" <?php $_POST['state'] ?>>Indiana</option>
 <option value="Iowa" <?php $_POST['state'] ?>>Iowa</option>
 <option value="Kansas" <?php $_POST['state'] ?>>Kansas</option>
 <option value="Kentucky" <?php $_POST['state'] ?>>Kentucky</option>
 <option value="Louisiana" <?php $_POST['state'] ?>>Louisiana</option>
 <option value="Maine" <?php $_POST['state'] ?>>Maine</option>
 <option value="Maryland" <?php $_POST['state'] ?>>Maryland</option>
 <option value="Massachusetts" <?php $_POST['state'] ?>>Massachusetts</option>
 <option value="Michigan" <?php $_POST['state'] ?>>Michigan</option>
 <option value="Minnesota" <?php $_POST['state'] ?>>Minnesota</option>
 <option value="Mississippi" <?php $_POST['state'] ?>>Mississippi</option> 
 <option value="Missouri" <?php $_POST['state'] ?>>Missouri</option>
 <option value="Montana" <?php $_POST['state'] ?>>Montana</option>
 <option value="Nebraska" <?php $_POST['state'] ?>>Nebraska</option>
 <option value="Nevada" <?php $_POST['state'] ?>>Nevada</option>
 <option value="New Hampshire" <?php $_POST['state'] ?>>New Hampshire</option>
 <option value="New Jersey" <?php $_POST['state'] ?>>New Jersey</option>
 <option value="New Mexico" <?php $_POST['state'] ?>>New Mexico</option>
 <option value="New York" <?php $_POST['state'] ?>>New York</option>
 <option value="North Carolina" <?php $_POST['state'] ?>>North Carolina</option>
 <option value="North Dakota" <?php $_POST['state'] ?>>North Dakota</option>
 <option value="Ohio" <?php $_POST['state'] ?>>Ohio</option>
 <option value="Oklahoma" <?php $_POST['state'] ?>>Oklahoma</option>
 <option value="Oregon" <?php $_POST['state'] ?>>Oregon</option>
 <option value="Pennsylvania" <?php $_POST['state'] ?>