[RESOLVED] Not sure what's wrong! mysql_query("INSERT INTO...

[stroix]

Well this is really strange, not sure what the problem is, I hope that you will be able to help me. Thank you!

Here is the form.html:

<form id="form1" name="form1" method="post" action="process.php">
  <table width="100%" border="0">
    <tr>
      <td><div align="center" class="style4">Last Name</div></td>
      <td><div align="center" class="style4">First Name</div></td>
      <td><div align="center" class="style4">BU ID#</div></td>
      <td><div align="center" class="style4">Building</div></td>
      <td><div align="center" class="style4">Room #</div></td>
      <td colspan="2"><div align="center" class="style4">Phone</div></td>
    </tr>
    <tr>
      <td colspan="7"><div align="center"><hr /></div>        <div align="center"></div>        <div align="center"></div>        <div align="center"></div>        <div align="center"></div>        <div align="center"></div></td>
    </tr>
    <tr>
      <td><div align="center">
          <input name="lastname" type="text" id="lastname" />
      </div></td>
      <td><div align="center">
          <input name="firstname" type="text" id="firstname" />
      </div></td>
      <td><div align="center">
          <input name="buid" type="text" id="buid" />
      </div></td>
      <td><label>
          <div align="center">
            <select name="building" id="building">
              <option>Ondrak</option>
              <option>Jaeger</option>
              <option>Neuzil</option>
              <option>Crum Hall - Floor 1</option>
              <option>Crum Hall - Floor 2</option>
              <option>Crum Hall - Floor 3</option>
            </select>
          </div>
        </label></td>
      <td><div align="center">
          <input name="room" type="text" id="room" size="10" maxlength="10" />
      </div></td>
      <td><div align="center">
          <input type="phone" name="textfield" id="phone" />
      </div></td>
      <td><input type="submit" name="Submit" id="Submit" value="Go!" /></td>
    </tr>
    <tr>
      <td>

    <div align="center"></div></td>
  <td><div align="center"></div></td>
  <td><div align="center"></div></td>
  <td><label>
      <div align="center"></div>
    </label></td>
  <td><div align="center"></div></td>
  <td colspan="2"><div align="center"></div></td>
</tr>
  </table>
  <label></label>
  <div align="center"></div>
</form>

And here is the process.php:

<?php

// 1. Create a database connection
$connection = mysql_connect("x", "x", "x");
if (!$connection) {
	die("Database connection failed: " . mysql_error());
}

// 2. Select a database to use
$db_select = mysql_select_db('ssagarco', $connection);

mysql_query("INSERT INTO car_program (lastname, firstname, buid, building, room, phone) VALUES ('$_POST[lastname]', '$_POST[firstname], '$_POST[buid], '$_POST[building], '$_POST[room], '$_POST[phone]')");

echo "1 record added";

mysql_close($connection)
?>

Thank you for your help.

[rulian]

Be sure to post the actual error you are getting, but what I see that you SHOULD enclose your table name and field names with `, your $_POST indexes need a " or a ', you need to read up on mysql_real_escape_string, and never put your form values straight into your sql, because it can at best, break your query and cause it to fail, at worse let someone completely destroy your database.

[stroix]

Thanks! =)