mysql syntax error inserting decimal, timestamp with php

Question

Im getting the error:

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 '10', '16:39:02', '292.35')' at line 1

this is the query im running in php:

mysql_query("INSERT INTO `copper` 
              (`month`, `time`, `price`) 
             VALUES 
              ('$month', '$time', '$price')") or die(mysql_error());

Here is a literal example:

INSERT INTO `table` 
  (`month`, `time`, `price`) 
VALUES 
  ('10', '16:39:02', '292.35')

this is my table setup

Answer 1

echo out your actual query so you can see what is generated.

$query = "INSERT INTO `copper` (`month`, `time`, `price`) VALUES ('$month', '$time', '$price')";   
mysql_query($query) or die(mysql_error() . '<br />Query: ' . $query);

Answer 2

This should work as you posted it, so here's a few wild guesses:

Are you sure $month doesn't contain a '?

Are you sure those are actually the right kind of quotes? i.e. not the exotic stuff that comes out of word processors these days? (did you copy&paste this from the web / pdf / doc?)

Otherwise, lose the newlines within the query, shouldn't matter but you never know.