help php mysql insert script

[dubfoundry]

Ok guys im new to php mysql and i'm trying to insert some form information in my database. Im using a script from sitepoint in which i went through the tutorial did some experiments of my own and it worked....

 

but now i'm getting this error which i cant figure out....

 

Error placing order: 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 'order SET product ='1', size='medium', color='', quantity = '1' at line 1

 

here is the page

http://vaughntucker.com/imagecon/hats.php

 

and this is the script

<?php 

//default page display

//connect to database

$dbcnx = @mysql_connect('p3nl41mysql7.secureserver.net', 'imagecon', 'Dub*boss_1');

if (!$dbcnx) {

echo '<p> Unable to connect to the '. 'database server at this time.</p>';

exit();

 

}

 

//select database

if (!@mysql_select_db('imagecon')) {

exit('<p>Unable to locate the ' .

    'database at this time.</p>');

}

 

//Mysql query add joke

if (isset($_POST['submit'])) {

  $product = 1;

  $size = $_POST['size'];

  $color = $_POST['color'];

  $quan = $_POST['quantity'];

    $sql = "INSERT INTO order SET

      product ='$product',

  size='$size',

  color='$color',

  quantity = '$quan',

      date = CURDATE()";

  }else{

  echo 'No data submited';

 

  }

  if (@mysql_query($sql)) {

    echo '<p>Your order has been submited.</p>';

  } else {

    echo '<p>Error placing order: ' .

        mysql_error() . '</p>';

  }

 

 

 

?>

 

thanks in advance

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

 

order is a mysql reserved word. Change your column name to something else.

[dubfoundry]

hey thanks bro that did it