[SOLVED] Inserting into DB Prob.

[fLaVV]

I get no errors, but when I click submit, the information doesnt show up in the database.

 

<?
if($_POST['submit']){
include("db.php");

$name = $_POST['name'];
$serial = $_POST['serial'];
$info = $_POST['info'];
$style = $_POST['style'];
$view = $_POST['view'];
$download = $_POST['dlink'];
$image = $_POST['vlink'];

mysql_query("INTERT into serach_templates (id, name, serial, info, style, view, download, image)".
"VALUES ('NULL', '$name', '$serial', '$info', '$style', '$view', '$download', '$image')");

echo "Results entered!";
}
else {

?>
<form action="addtemplate.php" method="post">
<table width="433" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td>Template Name:</td>
    <td>
      <input type="text" name="name" id="name" /></td>
  </tr>
  <tr>
    <td>Template Serial:</td>
    <td>
    <input type="text" name="serial" id="serial" /></td>
  </tr>
  <tr>
    <td>Information:</td>
    <td>
      <textarea name="info" id="info" cols="45" rows="5"></textarea></td>
  </tr>
  <tr>
    <td>Image URL:</td>
    <td>
    <input type="text" name="url" id="url" /></td>
  </tr>
  <tr>
    <td>Download Link:</td>
    <td>
    <input type="text" name="dlink" id="dlink" /></td>
  </tr>
  <tr>
    <td>View Link</td>
    <td>
    <input type="text" name="vlink" id="vlink" /></td>
  </tr>
  <tr>
    <td>Style:</td>
    <td><select name="style" id="style">
        <option selected="selected">--Select Style --</option>
        <option value="clean">Clean</option>
        <option value="dark">Dark</option>
        <option value="light">Light</option>
        <option value="futuristic">Futuristic</option>
        <option value="vector">Vector</option>
        <option value="retro">Retro</option>
    </select></td>
  </tr>
  <tr>
    <td> </td>
    <td><div align="center">
      <input type="submit" name="submit" id="submit" value="Enter Info" />
    </div></td>
  </tr>
</table>
</form>
<?
}
?>

 

Any suggestions?

[cooldude832]

add to your query or die(mysql_error());

 

and tell us what it says

[fLaVV]

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 'INTERT into serach_templates (id, name, serial, info, style, view, download, ima' at line 1

[chigley]

INTERT -> INSERT

[cooldude832]

good call on that, but as a rule of thumb add the or die before you come here

[fLaVV]

Omg...i feel like such a n00b now.../cry...thanks for the fast replys didnt mean to bother u all with such a stupid error...Really am sorry, but thanks again.

 

Thanks cooldude, your name says it all ...Yea i dont know why I didnt put that in..also thank you chigley for proving that i cant spell...but now I know to make sure i spell INSERT and not INTERT