[RESOLVED] sending data to mysql

[slrobinson1983]

Hello all. I'm having trouble getting php send form data to my mysql database. The database is called "uma" and the table it should be sending the data to is called "members". The code seems fine to me but i am new at this so i am probably overlooking something. Here is the form code...

<form id="create account" name="create account" method="post" action="createaccountdata.php">
  <div align="center">
    <table border="0">
      <tr>
        <td><div align="left"><span class="finestprint">Full Name</span></div></td>
        <td><div align="left"><span class="finestprint">Rap Name</span></div></td>
      </tr>
      <tr>
        <td><div align="left"><span class="finestprint">
          <input type="text" name="full_name" id="full_name" size=30/>
        </span></div></td>
        <td><div align="left"><span class="finestprint">
          <input type="text" name="rap_name" id="rap_name" size=30/>
        </span></div></td>
      </tr>
      <tr>
        <td colspan="2"><div align="left"><span class="finestprint">Password</span></div>          <div align="left"></div></td>
      </tr>
      <tr>
        <td colspan="2"><div align="left"><span class="finestprint">
          <input type="text" name="password" id="password" />
        </span></div>          <div align="left"></div></td>
      </tr>
      <tr>
        <td colspan="2"><div align="left"><span class="finestprint">Email</span></div>          <div align="left"></div></td>
      </tr>
      <tr>
        <td colspan="2"><div align="left"><span class="finestprint">
          <input type="text" name="email" id="email" size=30/>
        </span></div>          <div align="left"></div></td>
      </tr>
      <tr>
        <td><div align="left"><span class="finestprint">State</span></div></td>
        <td><div align="left"><span class="finestprint">Sex</span></div></td>
      </tr>
      <tr>
        <td><div align="left"><span class="finestprint">
          <select name="state" size="1" id="state">
            <option>-Select State-</option>
            <option>Alabama</option>
            <option>Alaska</option>
            <option>Arizona</option>
            <option>Arkansas</option>
            <option>California</option>
            <option>Colorado</option>
            <option>Connecticut</option>
            <option>Delaware</option>
            <option>District of Columbia</option>
            <option>Florida</option>
            <option>Georgia</option>
            <option>Hawaii</option>
            <option>Idaho</option>
            <option>Illinois</option>
            <option>Indiana</option>
            <option>Iowa</option>
            <option>Kansas</option>
            <option>Kentucky</option>
            <option>Louisiana</option>
            <option>Maine</option>
            <option>Maryland</option>
            <option>Massachusetts</option>
            <option>Michigan</option>
            <option>Minnesota</option>
            <option>Mississippi</option>
            <option>Missouri</option>
            <option>Montana</option>
            <option>Nebraska</option>
            <option>Nevada</option>
            <option>New Hampshire</option>
            <option>New Jersey</option>
            <option>New Mexico</option>
            <option>New York</option>
            <option>North Carolina</option>
            <option>North Dakota</option>
            <option>Ohio</option>
            <option>Oklahoma</option>
            <option>Oregon</option>
            <option>Pennsylvania</option>
            <option>Rhode Island</option>
            <option>South Carolina</option>
            <option>South Dakota</option>
            <option>Tennessee</option>
            <option>Texas</option>
            <option>Utah</option>
            <option>Vermont</option>
            <option>Virginia</option>
            <option>Washington</option>
            <option>West Virginia</option>
            <option>Wisconsin</option>
            <option>Wyoming</option>
          </select>
        </span></div></td>
        <td><div align="left"><span class="finestprint">
          <select name="sex" size="1" id="sex">
            <option>-Select Sex-</option>
            <option>male</option>
            <option>female</option>
          </select>
        </span></div></td>
      </tr>
    </table>
    <span class="maintextfont">
    <input type="submit" name="submitcreateinfo" id="submitcreateinfo" value="Submit" />
  </span></div>
</form>

And here is the code for the page that should be handling the data...

<?php

mysql_connect("localhost","root") or 
mysql_select_db("uma") or die( "Unable to select database");

$full_name = $_POST['full_name'];
$rap_name = $_POST['rap_name'];
$password = $_POST['password'];
$email = $_POST['email'];
$state = $_POST['state'];
$sex = $_POST['sex'];


$query=("INSERT INTO 'members' (full_name, rap_name, password, email, state, sex)VALUES ('$full_name', '$rap_name', '$password', '$email', '$state', '$sex')");

mysql_query($query) or die('Error Creating Account');
echo "Account created successfully"
?>

I keep getting the 'Error Creating Account' message (which is what I SHOULD be getting if there is something wrong). Any ideas? Thanks in advance.

[ixalmida]

If you want to debug something, you won't get much information from your own custom error message. Try outputting the actual error.

mysql_query($query) or die(mysql_error());

[slrobinson1983]

thanks that did actually help me figure out the issue. i think the quotation marks around "members was throwing everything off as well as some issues with my database.

[bradgrafelman]

Also note that user-supplied data should never be placed directly into a SQL query string, else your code will be vulnerable to SQL injection attacks and/or just plain SQL errors. Instead, you must first sanitize the data with a function such as [man]mysql_real_escape_string/man (for string data) or perhaps even prepared statements.