[SOLVED] error with Insert statement

[gammaman]

I am having no luck today.  I have an insert statement and I could sware it is correct.

mysql_query("Insert into CustomerOrder (ProductID,Amount) Values ('$Item','$Amt')");

[BlueSkyIS]

php/mysql will give you a clue about the error if you use or die(mysql_error()):

 

mysql_query($some_sql) or die(mysql_error() . "  $some_sql");

[dooper3]

It looks fine here... make sure your database columns are of exactly the same names as you have said in the query, and it's good practice to use capital letters for mySQL commands... so your code should look more like this:

 

myql_query("INSERT INTO CustomerOrder (ProductID,Amount) VALUES ('$Item','$Amt')");

;

 

Also try to avoid using capital letters in variables, they are more often used for classes and functions (I think!).

 

If it's still not working, show us what the actual error is that is coming up when you execute the query.

 

Hope that helps

[gammaman]

Works fine Now, weird but the only thing I added was the or die.