Me need some major help

[vbpowerhost]

Ok I am really getting angry at php,mysql coding at the moment.
Here is my problem when I use the form to post data into a table on my project it fill the tables with "0" only.

Here is the form code:

<form action="insert_new.php" method="post">
  <table width="812" border="0" cellpadding="2">

<tr> 
  <td width="355" nowrap> <div align="RIGHT">Buyers Name :&nbsp;</div></td>
  <td width="443" nowrap><input type="TEXT" name="buyer"> </td>
</tr>
<tr> 
  <td width="355" nowrap> <div align="RIGHT">Purchase Date :&nbsp;</div></td>
  <td width="443" nowrap><input type="TEXT" name="purchase_date"> </td>
</tr>
<tr> 
  <td width="355" nowrap> <div align="RIGHT">Warranty :&nbsp;</div></td>
  <td width="443" nowrap><input type="TEXT" name="warranty"> </td>
</tr>
<tr> 
  <td width="355" nowrap> <div align="RIGHT">Recieve Date :&nbsp;</div></td>
  <td width="443" nowrap><input type="TEXT" name="recieved_date"> </td>
</tr>
<tr> 
  <td width="355" nowrap> <div align="RIGHT">Year :&nbsp;</div></td>
  <td width="443" nowrap><input type="TEXT" name="year"> </td>
</tr>
<tr> 
  <td width="355" nowrap> <div align="RIGHT">Model :&nbsp;</div></td>
  <td width="443" nowrap><input type="TEXT" name="model"> </td>
</tr>
<tr> 
  <td width="355" nowrap> <div align="RIGHT">VIN :&nbsp;</div></td>
  <td width="443" nowrap><input type="TEXT" name="vin"> </td>
</tr>
<tr> 
  <td width="355" nowrap> <div align="RIGHT">Color :&nbsp;</div></td>
  <td width="443" nowrap><input type="TEXT" name="color"> </td>
</tr>
<tr> 
  <td nowrap>&nbsp;</td>
  <td nowrap> <div align="LEFT">
      <input type="SUBMIT" name="SUBMIT" value="Submit">
      &nbsp;&nbsp;&nbsp;
      <input type="RESET" name="RESET" value="Reset">
    </div></td>
</tr>
  </table>
</form>

And here is the insert_new.php code:

<? 
  if(!isset($_POST['buyer'])) 

  { 
     echo "You have not entered all the required details.<br>" 
          ."Please go back and try again."; 
     exit; 
  } 
   error_reporting(E_ALL);

  $buyer = addslashes($_POST['buyer']);
  $purchase_date = addslashes($_POST['purchase_date']);
  $warranty = addslashes($_POST['warranty']);
  $recieved_date = addslashes($_POST['recieved_date']);
  $year = addslashes($_POST['year']);
  $model = addslashes($_POST['model']);
  $vin = addslashes($_POST['vin']);
  $color = addslashes($_POST['color']);

  @ $db = mysql_pconnect("localhost", "root", ""); 

  if (!$db) 
  { 
     echo "Error: Could not connect to database.  Please try again later."; 
     exit; 
  } 

  mysql_select_db("testing"); 
   $sql = 'INSERT INTO `yamaha cruisers` (`buyer`,`purchase_date`,`warranty`,`recieved_date`,`year`,`model`,`vin`,`color`) VALUES ('$buyer','$purchase_date','$warranty','$recieved_date','$year','$model','vin','color')'; 
   $result = mysql_query($sql) 
or die("Invalid query: " . mysql_error());
 ?> 

If anyone can help please let me know I have the php and mysql manuals and they haven't helped yet.

[LordShryku]

Methinks you may be having trouble because of the single quotes. Since you're using single quotes to encapse your query, you will need to \ you single quotes around your values. Or, I would suggest, use double quotes to encapse your query. Like this...

$sql = "INSERT INTO `yamaha cruisers`  

         (`buyer`,`purchase_date`,`warranty`,
          `recieved_date`,`year`,`model`,
          `vin`,`color`) 
        VALUES  

         ('$buyer','$purchase_date','$warranty',
          '$recieved_date','$year','$model',
          'vin','color')";

And even better yet, escape the string when referencing a variable.

$sql = "INSERT INTO `yamaha cruisers`  

         (`buyer`,`purchase_date`,`warranty`,
          `recieved_date`,`year`,`model`,
          `vin`,`color`) 
        VALUES  

         ('".$buyer."','".$purchase_date."','".$warranty."',
          '".$recieved_date."','".$year."','".$model."',
          'vin','color')";

[vbpowerhost]

that didn't work either way still same thing.